Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to write the following in expressioon :
sum({<[fis_period] = {[Forecast Fiscal Period-1]} >}[Stag Forecast Units])
sum({<[fis_period] = {'$(=[Forecast Fiscal Period]-1)'} >}[Stag Forecast Units])
Hi
You can do this way,
sum({<[fis_period] = {=Max([Forecast Fiscal Period)-1]} >}[Stag Forecast Units])
Regards
Hi,
Try like this, if not works come up with an example
=sum({<[fis_period] = {$(=Max([Forecast Fiscal Period]) - 1)} >}[Stag Forecast Units])
Regards,
Jagan.
Please check the ex field. I want to calculate that field for all the BucketDescrition :
see the vw_fact_dop_forecast_stagger in the diagram :