Forum Discussion
Solved
Custom Measure in Report Displays G-14
Hello - I have a custom measures that are displaying G-14 rather than 0. Ideally if nothing was delivered the measuers should be zero. I've changed formatting and messed around with some other set...
What happens if you rewrite your measure like this:
Est. Net Cases =
CALCULATE( IF (SUM('Actual Sales'[NetCaseQuantity]) = BLANK(), 0, SUM('Actual Sales'[NetCaseQuantity])) , NOT 'Product'[Product Number] IN {"996002","996001"})
What happens if you rewrite your measure like this:
Est. Net Cases =
CALCULATE( IF (SUM('Actual Sales'[NetCaseQuantity]) = BLANK(), 0, SUM('Actual Sales'[NetCaseQuantity])) , NOT 'Product'[Product Number] IN {"996002","996001"})
Thanks for the reply but it did not change anything. GE-14 still visible.