Set analysis with <= operator

[#1]

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

[jagan · Accepted solution]

Hi,

Try this expression

=count( {$<week={"<=$(=Max(week))"}>} NR)

Hope this helps you.

Regards,

Jagan.

[#3]

Hi Jagan,

this works!

Thank you,

Eva

<p

[jagan]

Hi,

Close this discussion by clicking Correct Answer button, it helps others to find the answer for similar issues.

Regards,

jagan.