Adding 5 variables when 2 variables are null , in this total value not showing?

User Support Form Building
, ,
5

Hi @mahabbat
The issue can be resolved by reworking your calculations using the if functionality or the coalesce functionality as shown below

e.g. for If

(if(${crop1}=’’,0,${crop1}))+(if(${crop2}=’’,0,${crop2}))+(if(${crop1}=’’,0,${crop2})) + etc

e.g for colasce

coalesce(${crop1},0)+coalesce(${crop2},0)+ etc

This should sort out your issue with the blanks

Regards,
Stephane

1 Like