Skip to Content
Former Member
Jun 07, 2013 at 02:56 AM

BPC NW 10: calculate cells in input form (based in other input forms)


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.