For the sake of expediency and avoiding repeat entries, how does one allow empty fields to be assumed 0 for the calculation to be made?
Hi @ashia and welcome to the community!
To convert empty values to zero, you can use either the coalesce()
function or the if()
function.
coalesce(${potentially_empty_value}, 0)
if(${potentially_empty_value}=“”, 0, ${potentially_empty_value})
2 Likes