Recalc Measure Calculating Fine at Base Intersection Level But Not Working for Aggregate Levels
Hi,
We are trying to setup calculation for 2 measures as follows:-
bu_calc:
bu_wp_opt_prch
BUWpOptUnitPrchU = BUWpOTBU /BUWpOptStcoPrchU
BUWpOptStcoPrchU = BUWpOTBU / BUWpOptUnitPrchU
Both BUWpOptUnitPrchU and BUWpOptStcoPrchU measures have default agg of "Reclc" and default spread as "none". Both these measures have the same base intersection
The measures are calculating fine at the base intersection but when we aggregate the workbook and then try to enter value in any one of these 2 measures and hit calculate button then the calculation does not work.
Please can someone suggest how this issue may be resolved?
Thank you