Help with counting formula

[GregRyder]

Hi

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 · Accepted solution]

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]

Hi

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