Need help to write expression

[suvechha_b]

How to write the following in expressioon :

sum({<[fis_period] = {[Forecast Fiscal Period-1]} >}[Stag Forecast Units])

[MK_QSL]

sum({<[fis_period] = {'$(=[Forecast Fiscal Period]-1)'} >}[Stag Forecast Units])

[PrashantSangle]

Hi

You can do this way,

sum({<[fis_period] = {=Max([Forecast Fiscal Period)-1]} >}[Stag Forecast Units])

Regards

[jagan]

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.

[suvechha_b]

Please check the ex field. I want to calculate that field for all the BucketDescrition :

[suvechha_b]

see the vw_fact_dop_forecast_stagger in the diagram :