Forum Discussion

mwen90's avatar
mwen90
Icon for Helper III rankHelper III
4 years ago

If statement not totalling in matrix

Hi,    I have a scenario where I am trying to calculate Column A - Column B. However, some of my Column A items are 0, so the solution is negative Column B value.    Where this happens, I want to...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

mwen90 , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Make sure this is the new column

Column 2=  if([Column3]<0, blank(), [Column3])

mwen90's avatar
mwen90
Icon for Helper III rankHelper III
4 years ago

amitchandak  further, if I do the formula you suggested, the coloum 3 value isn't the same?

 

It's 199.85 in Column 3 , Column 4 is 240?

 

Cheers,