How to replace zero with null values

[azm_azm]

I have uploaded the data to SAC model. Now there are few 'zero' values in the upload file. Now, I want to make those values to 'Null'. I tried to reupload the same file with null values, but it is not overwriting the existing zero values.

Is there a way to update the zeros values with null values without deleting the facts from the model?

Anyone who has faced this similar issue or know the workaround in this case. Thier comments would be deeply appreciated.

[N1kh1l · Accepted solution]

 @azm_azm

If its a planning Model,

• Delete manually from stories
• Create a Data Action where you check if data is 0 then delete
• Delete all data and reload again without 0's but this will delete facts

  Simple Data action could be like this. You can add more me beset for other dimension

  MEMBERSET [d/MEASURE] = "Measure name"
  IF RESULTLOOKUP()=0 THEN
  DELETE()
  ENDIF

  Br.

  Nikhil