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.


try this it may work


  • unless you further expand on your answer, this is better suited as a comment – glls Apr 30 '19 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 '19 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.