Disticnt Count Summary off by 1 1

[fmrock]

Hey Everyone,

I am working on a change to an existing report. Bascily, I need to count the number for accounts that fall into certian catagories.

The Report pulls back all Charges, Payments, and Adjustments posted this year.

I summarize stuff, by what was posted yesterday, Month Todate, and Year to date.

Right now I have the following formula


If {Command.Post_Date} =(CurrentDate-1) Then
{Command.Account}
//Else
// ""

Then I am doing a distinct count on this, however, its counting the blank row and it shouldnt. Do you know of any way figuring out this count correctly?

BTW.. i am using CR9

 

[lbass]

The "" counts as 1. Create a formula {@null} by opening a new formula and saving it without entering anything. Then change your formula to:

If {Command.Post_Date} =(CurrentDate-1) Then
{Command.Account} Else
{@null}

You can use this same technique with numbers by using tonumber({@null}) as the default, and for dates, date({@null})

-LB

 

[fmrock]

This worked great. Thanks for the tip Lbass!