Hi Abdul

Try the calculation

{ Fixed [Company]: SUM(IIF([Purchased]="Y",1,0))}

Hi, Abdul

Try this

{ Fixed [Company]: AVG(IIF([Purchased]="Y",1,0))}

ZZ

Hi Abdul,

Check with below formula

Hopefully it help you.

SUM(IF {FIXED [Company] : COUNTD([Purchased])=1} then 1 else 0 end)

Thanks,

Ashfaque

I think you're after SUM not COUNT ..... COUNT will be 2 (as in 1 and 0) but SUM will be 1 ( 1 + 0 )

you [Purchased] is a integer?

ZZ

so it is something like this with your above sample data?

ZZ

Checked  it worked for me

SUM(IF {FIXED [Company] : COUNTD([Purchased])=1} then 1 else 0 end)

Given the example data above, there is no need to use an LOD here.  Wouldn't this work the same way ?

SUM(IF COUNTD([Purchased])=1 then 1 else 0 end)

Hi Abdul,

Its Humble request please mark any of the answers which was helpful to you.

And please close thread.

Thanks,

Ashfaque