Use expression in set analysis

[#1]

In a Text Box I have this expression that gives me (what i believe to be) the numeric value for the previous month

=num(month(min(flow_date)-1)))

If I hard code the {2} the straight table shows the avg value...

=(Sum( {$<flow_month={2}, flow_day={">=1<=31"}>} numeric_value_1) - Sum( {$<flow_month={2}, flow_day={">=1<=31"}>} numeric_value_2)) / count({$<flow_month={2}, flow_day={">=1<=31"}>} flow_date)

so... can how would I replace the {2} with the expression from the text box?

thanks,

James

[jykang0638 · Accepted solution]

Hi James,

You can use $ sign expansion syntax at the set analysis like this:
Sum( {$<flow_month={"$(=month(min(flow_date)-1))"}, flow_day={">=1<=31"}>} numeric_value_1)

I hope it will help you.

Steve Kang

[#3]

Steve,

Thanks.  I tried many variations, but yours led to the correct answer.

Note:  I added the num() back into the expression.  Something about my flow_month is a numeric value which did not match the result of month()

James