Skip to Content
0
4 days ago

sum certain values of a column with conditions in Crystal Reports

29 Views

Hi,

II have a table with 2 columns.
VAT rate (RATTAXLIN_0) and value (AMTTAXLIN_0)

in the table are values with 7 and 19 percent VAT rate.

I just want to sum up the ones that have 7 percent.

I thought this would be easy, but it doesn't work.
What am I doing wrong, how is it right?

if {SINVOICED.RATTAXLIN_0} = 7 then
sum({SINVOICED.AMTTAXLIN_0})

Thanks for help.