Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How Do I do tihs in SET Analysis
If(NET_INDEMNITY_PAID>1000000,1000000)
There is no aggregation of sum or count or avg ?
sum( If(NET_INDEMNITY_PAID>1000000,1000000,NET_INDEMNITY_PAID))
IF you just want to sum the NET_INDEMNITIES that are greater than 1M, then you should do
Sum( {$<NET_INDEMNITY_PAID={">1000000"}>} NET_INDEMNITY_PAID)
If you want to do something else, I do not think Set Analysis is the right tool.
HIC
You could set a "flag" in the data based on Indemnities Less than or Greater than 1000000.
Then use ths in the set analysis