[ad_1]
Hello
Hi It is possible to have a default value in “Calculated fields” if the value is invalid instead of 0 value?
Filedname8: PREC(fieldname2*fieldname6*fieldname7/1000000,2)
Example Result: X.XX
I have to 2 Decimal value in the end, some of the user put lowest value but the result if showing 0 value
and for final Result – We Want to Default Value example 9,500 instead of 0 in this field.
Fieldname9: ROUND(fieldname8*9500,true)
is this possible?
- This topic was modified 5 hours, 21 minutes ago by .
The page I need help with: [log in to see the link]