Dynamic Expression

[nareshthavidishetty]

Hi,

How to make the below expression as dynamic.

sum({$<FISCALYEAR={"FY2016"}>}Qty)

For ex: on 02/01/2017 the FISCALYEAR should changed to FY2017 which i need to do it dynamically.

Thanks..

[sunny_talwar · Accepted solution]

May be this:

Sum({$< FISCALYEAR = {"$(='FY' & Year(YearStart(Today(), 0, 2)))"}>} Qty)

[nareshthavidishetty]

Hi,

Is the below approach is correct?'

In Script: right(FISCALYEAR,4) as Year,

In Chart : sum({<Year={'=max(Year)'}>}Qty)

Thanks..

[sunny_talwar]

I guess... but the expression would be

Sum({<Year = {$(=Max(Year))}>} Qty)