>= sign not working in SET analysis

mphansalkar — Fri, 06 Nov 2020 03:53:13 GMT

hi,

I am trying to use the following set analysis and running into the issue. I am counting number of claims by region ID.

sum({<RegionId = {2}>}PI_TotalClaimCnt) - this works ,

However I need to get claims for all regions with Region ID >= 2.

sum({<RegionId = ">={2}">}PI_TotalClaimCnt) - THIS DOES NOT WORK.

I have tried possible combinations of single quotes, double quotes, num(RegionID) however no luck yet.

Both fields are integers, but this formula is giving 0 value. Please help asap.

thanks

Madhura

Re: >= sign not working in SET analysis

MayilVahanan — Fri, 06 Nov 2020 05:26:32 GMT

Try like below
sum({<RegionId = {">=2"}>}PI_TotalClaimCnt)