Share
Report
12Hi, Please kindly help me with the formula..
Am new to power apps and struggling how to create calculated formula for below senario.
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
All responses (
Answers (
