Count if formula needed

[Former Member]

I have to count dates. But the condition is, the data of one field should be greater than 0.

So if Amt >0 for a date then count that date as 1 and so on.

I tried to formulate it as:

If(Amt >0) then(count(date))

But I have groups on month field and orgnization field.

How will the formula change? I addded count({date},{@month}) but it shows 31. I want 31 - number of dates in which amt <=0

Thanks

[abhilash_kumar · Accepted solution]

Hi Anushree,

1) Create a formula with the code:

If {Amount_field} > 0 then 1

2) Go to Insert > Summary > Choose the above formula field as the 'Field to summarize' > Place the result on the Group Footer for Month

Hope this helps.

-Abhilash

[abhilash_kumar · Accepted solution]

Oh and make sure the 'Summary Operation' is 'Sum'.

-Abhilash

[Former Member · Accepted solution]

Yes that was pretty clear.

Thanks.