topic Creating a nest if statement with set analysis in App Development

Creating a nest if statement with set analysis

curt1094 — Thu, 28 Sep 2023 18:51:16 GMT

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.

Re: Creating a nest if statement with set analysis

BrunPierre — Thu, 28 Sep 2023 20:59:06 GMT

Try

Count({$<KPI.KPI = {16}, ERRORS.BUSINESS_PROCESS -= {"LABOR"},

ERRORS.TOT_TRANS_AMT={"*"}> * <ERRORS.TOT_TRANS_AMT={">0"}>} ERRORS.BUSINESS_PROCESS)

Re: Creating a nest if statement with set analysis

curt1094 — Thu, 28 Sep 2023 23:33:22 GMT

Thanks, this produced the result I was looking for.