Hi 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.
stampcoin
17
mmbr1606
15
Super User 2025 Season 1
ankit_singhal
11
Super User 2025 Season 1