Hello Everyone,
I am desperately looking for help with multi-row calculation (it is always giving me a headache).
Fields with "no color" are the input file fields, where as columns in "pink" are calculated fields based on a logic.
Column E = brings Column D values, based on Column B values that are found in Column A. For example (as in xls), first 3 rows have Column B = "Value I", we need to search Column A for "Value I" and then place Column D values into Column E (first 3 rows respectively). We do need to make sure that Reporting Period is taken into consideration.
Column F = easy, and is a difference between columns E and F (no need help there)
How do I build a logic to do so?
thank you!
Marina
