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.