Hi Andre,

What is the value of the {% comm} field? Perhaps you are dealing with a double negative? I recommend when creating Calculated Columns or Filters to at least temporarily put all values you are using for formulas as columns in your inquiry. This way you can be sure that the calculations are using the values you expect.

For example, if {True Amount} is negative and also {% Comm} is negative, the result of multiplying will always be postive.
_________________________
Regards,
Softrak Tech Support