I’m trying to created a sales report that has year to date and month to date sales info by office and producer. My query is bringing back office, producer, commission, and a process date.
My report contains contains commissions by office by producer. The revenue values are ytd because the rows brought back have a full years worth of info. I’ve tried to add a column which checks the process date and only show the commission amount if the process date month is the same as the current date month. It looks like:
=(If(=) Then Else (0)).
This gives me an #ERR. If I add the process date to the report as a column then the formula works.
I’ve tried fooling with the extended syntax, but haven’t been successful. However,I think that’s the way to go.
Although DRathburn’s solution is a very good one, there is an alternative. You can use a formula like = Where (=). If you do this, then you don’t have to include the formula in
In a message dated 98-10-25 17:38:48 EST, you write:
I’ve tried to add a column which checks the process date and only show
the commission amount if the process date month is the same as the
current
date month. It looks like:
=(If(=) Then Else (0)).
This gives me an #ERR. If I add the process date to the report as a
column
then the formula works.
Although DRathburn’s solution is a very good one, there is an alternative. You can use a formula like = Where (=). If you do this, then you don’t have to include the formula in the block. The only limitation of the Where staatement is that you can only use ‘=’. With If logic you can use all of the boolean operators.
You can use a formula like = Where (=). If you do this, then you don’t have to include the formula in the block. The only limitation of the Where staatement is that you can only use ‘=’. With If logic you can use all of the boolean operators.
I’ve tried using the Where operator, but I get a syntax error. I believe it’s because a constant is expected after the equal sign. Where ( = 1) works.