Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @mphansalkar
Try like below
sum({<RegionId = {">=2"}>}PI_TotalClaimCnt)