Replacement of NULL values not working

[tb102122]

Hey all,

I am trying to replace NULL values with 0 in my pivot table.
Any idea why the settings are not working in case of this measure?

[duncan]

Hello @tb102122

I would try the solution from the topic:

Replace blank/NULL values by 0

Hi! I’m creating a WBR visual with the Receive Accuracy metric. The logic for RA metric is= POs correctly received/total POs There are some weeks where we don’t have any POs delivered in specific regions, so we have rows for that week with null values. [RA_wbr] I want to substitute those null values by ‘N/A’. I first tried to edit format data for null values, but it’s not working. Then I tried the following calculated field formula, but it gives me error and I’m not able to save it: [ra_form…

[fernandodenitto]

Many often it’s a problem of data type. Please, check your dataset and for example, if the original type was a string set into a number, or viceversa, is the field in not a calculation over and aggregation you can set to string.
At the end, the important is that you define exactly what you want in the dataset and not into the analysis.

Let me know if it works or if you need helps just text me. Happy to help!