Replacing an expresion with a Expansion using Variable

[wgonzalez]

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.

[Oleg_Troyansky]

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

[wgonzalez · Accepted solution]

Nice!  It worked, Thanks!