Sum formula in if Then statement

[donnarenia]

What is wrong with this variable formula? I need to pull out all adjustment amount from one table and have them show as well as all Final Bill Amounts. If it is an adjustment amount I need it to show as a negative.

WhilePrintingRecords;
currencyVar adjustment;
currencyVar InvoiceAmt;

adjustment :={CASH.Type}="A" , {CASH.Amount};
invoiceAmt :={AR.Type} ="P", {AR.FinalBillAmt};

Can someone help....PLEASE

 

[fisheromacse]

//{@Formula}
currencyvar adjustment;
currencyvar invoiceAmt;
if {CASH.Type}="A" then adjustment := {CASH.Amount}*(-1) else 0;
if {AR.Type}="P" then invoiceAmt := {AR.FinalBillAmt} else 0;

adjustment &" "&invoiceAmt


I am not sure how you want to display the resulting information. The above does the logic, then simple displays the 2 values separated by spaces.

It may be easier to create 2 formulas, one for adjustment and one for invoiceAmt if you have other calculations to perform.