Share
ReportHi Experts,
I have developed a power app but facing some issues while doing some calculation.
I have a table in the data verse sample is shown below.
| Stage | Volume | sent to next stage |
| Harvest | 10000(input value) | .4 |
| Primary processing | =(10000*0.4) | .5 |
| Further processing | =(10000*0.4*0.5) |
In the forms where user can enter the values of volume column and sent to next stage. i.e. green colour shows the input and red shows the calculated field.
I want to create lookup or something which help me to calculate below
if stage =harvest then volume = 10000 (initial user value)
if stage = primary processing then volume = 10000*0.4 (harvest(volume)* harvest(sent to next stage)
if stage=further processing = then volume = 10000*0.4*0.5( harvest(volume)* harvest(sent to next stage)*primary processing(sent to next stage).
I need help how should I approach to this.
I would really appreciate your reply.
All responses (
Answers (
529
