I'm using a compare table and some values in my datasets doesn't exists. So when I'm trying to calculate the percentage between two rows I got no values. For example I got this image :

compare table

In the forst line I got Null and 186. So I would like to replace the Null to a 0 and get something like : (0-186)/186 and get -100%. So I would like to know if it's possible to replace the value in JSON because with SAQL it would prevent me to dynamically sort my table.

2 Answers 2


try this it may work


  • unless you further expand on your answer, this is better suited as a comment
    – glls
    Apr 30, 2019 at 12:58

Try making use of coalesce (field name,0) it will any NULL value for the field with 0. Hope this helps.

  • I want to do it in JSON, I don't know if it will works.
    – Jack
    Apr 23, 2019 at 8:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.