if(prop("Burned") == toNumber("") and prop("Consumed") == toNumber(""), toNumber(""), prop("Burned") - prop("Consumed"))
if(prop("Burned") == toNumber("") and prop("Consumed") == toNumber("")
Check to see if both Burned and Consumed are blank (including no 0
). toNumber("")
is equal to nothing, as opposed to 0
toNumber("")
If they're both blank, return nothing.
prop("Burned") - prop("Consumed"))
If either have a value (including 0
), subtract the Consumed value from the Burned value.
<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
</aside>