Share
Report
12Please kindly help me with the formula..
Am new to power apps and struggling how to create calculated formula for below scenario.
I have 2 galleries. One port gallery and other Consumption Gallery.
I need to calculate a field Budget in Consumption gallery using percentage calculation of each from from Port Gallery and cost from SharePoint list.
Budget field in Consumption gallery = first port [(50 % of 4800) * Total cost of port CNHUA and Commercial Name Alexa 40 from pricelist ie 2.415] + Second port [(50 % of 4800) * Total cost of port CNFAN and Commercial Name Alexa 70 from pricelist ie 2.1]
Budget = 2400 * 2.415 + 2400 * 2.1 It should be like that.. cost values are taken from priceList sharepoint list. based on portcode from 1st gallery and commerical name from second gallery..
PriceList
TIA
All responses (
Answers (
