Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=Sum(num_leads) / Sum(num_users). I have this expression. Right now it returns 1 but I need it to be 1.25 and can't get it to show me the decimal value.
Any suggestions?
Hi,
You can use this : NUM(Sum(num_leads) / Sum(num_users),'0.00')
Regards,
Sokkorn Cheav
In properties,there is a sheet "number". You can set 2 decimal here.
Hi,
You can use this : NUM(Sum(num_leads) / Sum(num_users),'0.00')
Regards,
Sokkorn Cheav
num(Sum(num_leads) / Sum(num_users),'#0,00')