Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to create a nest if statement that allows me to search a field called [KPI.KPI] for a value of 16 then counts records for [ERRORS.BUSINESS_PROCESS] where [ERRORS.BUSINESS_PROCESS] not "LABOR" and the field [ERRORS.TOT_TRANS_AMT] is not 0 and not null. I was thinking it should be written like this, but I have had no luck.
If( KPI.KPI = 16,
If( [ERRORS.BUSINESS_PROCESS] -= {"LABOR"} and [ERRORS.TOT_TRANS_AMT] -= {"0", null},
Count([ERRORS.BUSINESS_PROCESS] )
)
)
Any help would be greatly appreciated. Thank you in advance.
Try
Count({$<KPI.KPI = {16}, ERRORS.BUSINESS_PROCESS -= {"LABOR"},
ERRORS.TOT_TRANS_AMT={"*"}> * <ERRORS.TOT_TRANS_AMT={">0"}>} ERRORS.BUSINESS_PROCESS)
Try
Count({$<KPI.KPI = {16}, ERRORS.BUSINESS_PROCESS -= {"LABOR"},
ERRORS.TOT_TRANS_AMT={"*"}> * <ERRORS.TOT_TRANS_AMT={">0"}>} ERRORS.BUSINESS_PROCESS)
Thanks, this produced the result I was looking for.