Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to replace this long expresion NetWorkDays(MonthStart(min(DTPunchDate)),MonthEnd(max(DTPunchDate))))
with an Expansion Variable. The intention is to simplify the expresion in the chart.
Have anyone done this before? How?
Thanks,
Wilfredo.
Nice! It worked, Thanks!
Yes, simply create th variable and store the formula there as a text. If you decide to use it in the load script, use SET statement rather than LET.
Then, in the chart, simply recall the variable using $-sign expansion:
SET vFormula ='NetWorkDays(MonthStart(min(DTPunchDate)),MonthEnd(max(DTPunchDate))))';
Expression:
$(vFormula)
cheers,
Oleg
Nice! It worked, Thanks!