Allow users to input and dynamically calculation with certain formula

[YuChing]

Hi there

I've created multiple galleries to allow users to input data for different data measures across weeks

For example - Users can change values of Backlog/FOH/SLC/DGP, and also 13wk Supply and Fcst

And I'd like to dynamically calculate [Prj Inv] (the last section) as per the values users key in across weeks

For example:

- W1 Prj. Inv = (FOH+SLC) + W1 Supply - (Backlog + W1 Fcst)

- W2 Prj. Inv = (FOH+SLC) + W2 Supply - (Backlog + W2 Fcst)

But after I applied the formula, I found all IDs are fixed with the selected-Week qty of ID1, so as you can see in the above pic, ID2 and ID3 [Prj Inv] is the same value as ID1...tried to search online but can't find the right use case to follow...hope somebody can help, thanks!!

[rubin_boer · Accepted solution]

hi @YuChing the text input in the gallery requires to be identified. 

have a look at this:

Gallery1 have two textinputs (TextInput1 and TextInput2) and 5 rows identified by ID

Gallery2 expression to add the two textinputs will look something like this

 Value(LookUp(Gallery1.AllItems, id = ThisItem.id).TextInput1.Text) + Value(LookUp(Gallery1.AllItems, id = ThisItem.id).TextInput2.Text)

hope this helps you

[RandyHayes]

@YuChing 

As requested from your other post - I am taking a look at this one too.

Was the information provided by @rubin_boer able to help or do you need a working solution for this problem still?

[v-albai-msft]

Hi @YuChing ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Best regards,

Allen

[YuChing]

Thank you @rubin_boer  @RandyHayes  @v-albai-msft  following Rubin's solution with a few tries, it works fine for me!!😊