Forum Discussion
subtract refunds from purchases
There are a few ways. Probabaly easiest is to write a measure (or two)
total raw amount= sum(apprasialaccount(amount)
total sales =calculate([total raw amount],appraisalaccount[refund]=“False”)
total refunds = -calculate([total raw amount],appraisalaccount[refund]=“True”)
total amount = [total sales]+[total refunds]
note the negative sign in front of refunds
All working now, Tanks
Community ChampionThere are a few ways. Probabaly easiest is to write a measure (or two)
total raw amount= sum(apprasialaccount(amount)
total sales =calculate([total raw amount],appraisalaccount[refund]=“False”)
total refunds = -calculate([total raw amount],appraisalaccount[refund]=“True”)
total amount = [total sales]+[total refunds]
note the negative sign in front of refunds
Hi, I have a similar problem, only I need to produce counts of transactions. With my data the refunds balance out, but the original transaction and the refund will be counted as two transactions - I want to count them as 0 transactions. How would I get around this?