Any iq gurus lurking? Need help with formula

[ODTech]

[SUM(IIF(<Transactions."CODE"> = '10004',<Transactions."QUANTITY">,0))]

[SUM(IIF(<Transactions."TCode"> = 'IN',<Transactions."QUANTITY">,IIF(<Transactions."TCode"> = 'CN',-<Transactions."QUANTITY">,0)))]

On the report we want to subtract sales and returns to only show the amount of moved stock but the above formula show the combined sales and returns. How do we get it to subtract and not add?

 

[Hamster]

Maybe try something like:

sum(value1, value2*-1)

?

 

[maumau]

@ODTech did this solution work?