Kevin good morning, first of all thanks for the answer, i need to create a calculated field to subtract the value column based on the transaction column ( out-in).
1 of 1 people found this helpful
I Solved it!
i created 2 calculated fields
IF [ transaction]= 'out' THEN ([value])
IF [ transaction]= 'in' THEN ([value])
then i created calc1-calc2