Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to replace empty/blank cell to zero?

Hi, I have a measure to calculate the Volume Impact. But some of the cell in [Volume Sum] is blank.  If the [Volume Sum] is blank, I want it to be set as zero so that it could calculate the volume i...
  • v-xiaotang's avatar
    4 years ago

    Hi Anonymous 

    I tried, change the blank cell to zero won't help,

    But values become correct when I try this,

    So you may need to check the code in variable _a.

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.