Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Dynamic financial year in set analysis

Hi All,

I have following expression here I want to take dynamic financial year(In Set expression) as per user selected '2016-2017' and  '2017-2018' how to achive this.

Thanks,

Krishna

1 Reply
jaumecf23
Creator III
Creator III

Hi,

Try this : sum({<Year={">=$(=max(Year)-1) <= $(=max(Year))"}>}Amount)