Expecting a logic
Hi Anaplanners, The setup is quite self explanatory .
Rate% in the source module is a fixed set of percentages. It could be anything, the numbers shown above is just for the demonstration.
Rate-Overlay in the Target Module is user inputted field. User is supposed to input the overlay numbers here.
The yellow shaded field is the expected final output. I am expecting your help in writing a formula here.
Constraint - You are not allowed to add any additional line item