Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, All,
I have a variable formulas to show YTD budget. But when I select Jan - Jun, it will always shows YTD budget instead of Jan - Jun.
How can I show selected value when I apply filer, and show YTD value when I do not have filter?
Sum({<Version={"Budget"},[Calendar Year]={$(=maxstring([Calendar Year]))},
Month={'<=$(=(max({<Month={$(=month(today()))}>}Month)))'}>}[Net Sales])
use below expression :-
=sum({<Year={"$(=max(Year))"},Month={"<=$(=num(month(Max([Start Date]))))"}>} value)
YTD:-
JAN-MAR:-
use below expression :-
=sum({<Year={"$(=max(Year))"},Month={"<=$(=num(month(Max([Start Date]))))"}>} value)
YTD:-
JAN-MAR:-