Solved

# Crystal Reports - Formula - Sum field based on field value

Posted on 2014-11-13

I need to programmatically calculate a grand total. I have a PostTax field which contains either a 1 or 0. I also have an amount field.

So, if the PostTax field contains a 1 I need to sum all values and it can result in a negative value so I need to default it to 0 if that happens.

Then I need to add the above result to the sum of amount where PostTax = 0.

I'm trying to write this in a formula. This is in a subform and the only purpose is to return the grandtotal.

Any ideas?