Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello @ all,
I have a set analysis expression that counts field values based on the selection of a week (in field 'week') and all weeks before.
Strange thing it works with a variable, but not with the field in the set analysis:
=count( {$<week= {"<= $(=Selected_Week) "} >} NR) --> this works, field value of 'week' is represented by variable 'Selected_Week'
=count( {$<week={"<=week"}>} NR) --> this returns always 0
Any ideas how to get it to work with the field value instead of the variable value?
Thanks, Eva
Hi,
Try this expression
=count( {$<week={"<=$(=Max(week))"}>} NR)
Hope this helps you.
Regards,
Jagan.
Hi,
Try this expression
=count( {$<week={"<=$(=Max(week))"}>} NR)
Hope this helps you.
Regards,
Jagan.
Hi Jagan,
this works!
Thank you,
Eva
<p
Hi,
Close this discussion by clicking Correct Answer button, it helps others to find the answer for similar issues.
Regards,
jagan.