Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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