We have added custom row in kreport called Final Amount.
We are doing field1 - field2 to calculate amount for Final Amount column.
Now, we want to display only -negative values in the table. How to do it?
@rsp Here is an example:
I am using Opportunities and I just created negative values by doing a -50000 on the field amount:
Then in the Filter Tab I use the same custom SQL. Caution: under Filter {f} will not be replaced by the field name. So write the field name directly
1 Like