Hi everyone, I need some guidance on how I can subtract total return. I want to be able to subtract $3,500 - $125 =$3375 and $125 - $3,500=$-3375 and so on as it drilldowns.
I created the following variables:
vVendor1 = IF(Vendor='Vendor1', SUM([Job Net]))
vVendor2=IF(Vendor='Vendor2', SUM([Job Net]))
Created a new measure and inputted the following, but it doesn't give me the results I need:
IF(Vendor=Vendor1, $(vVendor1) - $(vVendor2),
IF(Vendor=Vendor2, $(vVendor2) - $(vVendor1)))
Attached is the example of my data. Please help! Thank you!
