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"})
This seems to work but I'll need to verify overall numbers:
Est. Net Cases = ROUND(CALCULATE( IF (SUM('Actual Sales'[NetCaseQuantity]) = BLANK(), 0, SUM('Actual Sales'[NetCaseQuantity])) , NOT 'Product'[Product Number] IN {"996002","996001"}), 5)