topic Re: Help with counting formula in App Development

Help with counting formula

GregRyder — Mon, 18 May 2026 06:18:32 GMT

I am trying to count the number of transactions where loyalty flag is 1.

Here is my formula so far

if(Loyaltyflag=1, (Count(distinct If(TCODE='IN', REFERENCE))))

Loyalty flag is either 1 or 0

TCODE stands for transaction

REFERENCE is the invoice number

it says there is no error but it is not returning a value

Thanks

Greg

avinashelite — Mon, 18 May 2026 07:16:43 GMT

If its not returning value means , either it doesn't have data or the conditions are not correct, check the data once.

Better way to do is using set analysis

count(distinct {<Loyaltyflag={1}, TCODE={'IN'}>} REFERENCE)

GregRyder — Mon, 18 May 2026 13:44:15 GMT

Thanks that worked and I also gave the idea how to fix my formula.