I am currently trying to Sum transactions where they are positive on a Sell and Negative on a Buy.
My 'transaction type' choice field is a Buy/Sell choice.
My SD date projects out how many days away the transactions are.
For this first column in my Clearcollect I have tried using an IF statement depending on whether my transaction is a Buy/Sell.
If the transaction is a Sell I am trying to Sum that trade amount positively, if its a Buy I am trying to Sum that trade amount as a negative number in order to show the net difference, hence the Else is 'trade amount' * -1
Currently I have tried using below below for the condition of the If statement - but none work:
[@'transaction type'].Value = "Sell"
'transaction type'. Value = "Sell"
'transaction type'= "Sell"
'transaction type'= 'transaction type'. Sell
Below is the current state of my code and the output on my App