Empty question field to assume "0" for expediency

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