Column that indicates if item was sold during period


#1

In some analysis I need to filter the items that were sold or not during period. I created simple column that must indicate it
IS_Sold = IF (OR(OR([Sales Amount]=BLANK(); ISBLANK([Sales Amount]));[Sales Amount]=0) ; “NO”; “YES”)

No works well http://prntscr.com/n9ya9k
but if I select YES I have in list sold and not sold items http://prntscr.com/n9ybae


#2

For this I would probably simplify it a little bit by making sure no sales is equal to zero first of all.

This way you formula can be much simpler.

IF( Yes is selected, CALCULATE( Total Sales, Total Sales > 0 ), CALCULATE( Total Sales, Total Sales = 0 )

Something like the above.

You might have to play around a little with this, but this is the logic you need to create.