Sum formula 2

[tonyvee1973]

Hi all

I have a formula which shows sales figures for each customer and called it {@discount}
Then i created a "Sum of" that formula to give me a summary and it shows as "sum of @discount"

Now i need to only show that "Sum of @discount" figure if it is within a date range but cant seem to get it working.

I created a formula below but i keep getting errors "Field name is not known"

if {ORD_HEADER.OH_INV_DATE} in {?Enter Start Date} to {?Enter End Date} then sum of {@discount}


Any ideas?

 

[IanWaterman]

you can filter dates in select expert

{ORD_HEADER.OH_INV_DATE} in {?Enter Start Date} to {?Enter End Date}

Then your sums will only be for those dates

Ian

 

[lbass]

Or change your formula to:

if {ORD_HEADER.OH_INV_DATE} in {?Enter Start Date} to {?Enter End Date} then
{@discount}

Then insert a summary on this formula.

-LB

 

[tonyvee1973]

Thanks Guys, appreciate the help.

LB - i ended up using your solution, worked like a charm

Thanks again