Search code examples
crystal-reports

Concatenate - sign with numeric in Crystal Report

I want to Concatenate - sign with numeric I tried but not working. I just want to add - sign with the calculation result value. Code is mentioned below.

if ({Sp_ProductLedger;1.QtyOut}) >0 then
"-" &({#RTotal0} + {Sp_ProductLedger;1.Opbal});
Solution

  • If you want a numeric result that is negative, multiply by -1 instead of adding a minus sign (which would result in a string rather than a number).