hi bpc gurus:
I m building 3 input forms on a single sheet, like this:
But I have a doubt on how to build the Input Form "Cost", since every cell of this input form is calculated by multiplying input form "Sell" and input form "Rule" (the user doesnt have to input anything in input form "Cost", BPC must calculate every cell). How can I achieve this? Obviously when the user press "Save Data", BPC must save the data of the 3 input forms.
is there some way to achieve this?
PS: the number of rows of these 3 input forms is the same, they can change based on the context values which affect the 3 input forms.