Hi guys i have a problem, i made a calculation to exclude 0 value in the data using the calculation as a filter, but the data still showing the 0 value. here's the data
ps : hide/show 0 value was my filter
and also this's my calculation for count mtd or ytd
can you guys help me about this problem?
IF SUM(net Sales Current Year)=0 and SUM(net Sales previousYear)=0 THEN 0 else 1 end
This is your calc for Show/hide