Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have one expression as - sum((if(aggr(sum(TOTAL_PA_CAT_CLAIMS_LOCAL),CLAIM_ID_KEY)> vCatastrophic, TOTAL_PA_CAT_CLAIMS_LOCAL)))
i want to use set analysis instead,
i tried -
SUM(DISTINCT {<CLAIM_ID_KEY={'=sum(TOTAL_PA_CAT_CLAIMS_LOCAL)> $(vCatastrophic)'} >} TOTAL_PA_CAT_CLAIMS_LOCAL)
but not giving expected result, Please let me know correct expression for same
Thanks in advance
Try this.
SUM({<CLAIM_ID_KEY={'=Sum(Aggr(sum(TOTAL_PA_CAT_CLAIMS_LOCAL),CLAIM_ID_KEY))> $(vCatastrophic)'} >} TOTAL_PA_CAT_CLAIMS_LOCAL)
Regards,
Kaushik Solanki
This expression also giving same result as i used earlier set analysis
Try changing CLAIM_ID_KEY to other field which is unique in your data.
Regards,
Kaushik Solanki
Hi Ankit,
What is your expectation, can you give a sample output.
Many Thanks
Karthik
Why Sum(DISTINCT...)? I mean it is highly discouraged to use DISTINCT with sum.... Also, you if statement did not use Dollar sign expansion... may be don't use in set analysis also... Finally, use double quotes instead of single quotes for your search string.....try this
Sum({<CLAIM_ID_KEY = {"=Sum(TOTAL_PA_CAT_CLAIMS_LOCAL) > vCatastrophic"}>} TOTAL_PA_CAT_CLAIMS_LOCAL)