Hi,
I need some help with a formula/modelling. I have a module dimensioned by Products and returns (row) and measurement periods (columns) (1 yr, 3 yrs etc). My line items are actual performance and benchmark performance (see screenshot below). Products may track performance against more than one metric (e.g. Returns A and Returns
. However, in my final report, I want to only select 1 per product (so I've created a boolean for this). How do I create a formula which states, depending on the boolean, select the actual and benchmark performance for that product?
Thanks
