I have added a table to my report that summarizes the tax rates of my products (10 or 21%). I have 5 columns in the table with these calculations:
- Column-1: $F(field1)
Column-2: $F(field2)
Column-3: = field1 * field2 / 100
Column-4: = field2 + (field1 * field2 / 100)
Column-5: = CASE field1 WHEN 10 THEN (field2*1,4/100) When 21 Then (field2*5,2/100) ELSE 0 END
If I include the first 4 columns (and their calculations), the table is shown and works perfectly but if I add the fifth column (conditional statement) it does not work.
I have two questions:
- How could I include the conditional statement correctly so that the table is shown and works?
- Could I replace the fields in the calculation of column-4 with the column values (column-2 + column-3)?. What would be the correct expression?.
I want to clarify that I can include the conditional statement in the SQL query and it works perfectly with CASE expression but I do not know how to add it directly to the table.
Thank you very much.
Best regards,
Sergio