Sum on Converted Number Value 1

[schief13]

Using CR 11 Pro, SQL Database

I have a formula that converts the result of one formula to a negative based on a parameter.

if {TRXHISTORYHDR.TRXTYPE}= 3
then -{@Total Amount}
else {@Total Amount}

Once I convert the number to a negative I need to sum the result on the report. The sum function is treating the converted number as a positive number and adding it to the sum instead of subtracting.

Below is the result I am looking for.

Total Amount
1000.00
500.00
-500.00
------------
Sum 1000.00

Thanks in Advance for any help.

 

[lbass]

What is the content of your formula {@Total Amount} (and of any nested formulas)? In what report section are you placing this formula?

-LB

 

[schief13]

The formula {@Total Amount} is a simple addition of the invoice amount plus sales tax and is in the detail section of the report. There are no other formulas in the report. Hopefully I am giving you enough info. I appreciate the response.

 

[lbass]

I am asking for the actual formula.

-LB

 

[schief13]

Sorry,

{TrxHistoryHdr.InvoiceAmt} + {TrxHistoryHdr.SalesTaxAmt}

Thanks

 

[lbass]

Your formula to make the result negative in certain cases should work as is. Make sure you are inserting the sum on the conversion formula and not on {@Total Amount}.

-LB

 

[schief13]

-LB

Thanks for your input. You were correct I found another issue not related to the formula which solved my problem.

Thanks