AnsweredAssumed Answered

Can we assign default value for a Calculated Field

Question asked by info_tel on Apr 16, 2012
Latest reply on May 8, 2012 by info_tel

We are using a calculated field which gives the product of two number fields. Is it possible for us to assign a default value i.e. apply NVL logic to the calculations so that my calculated field always returns some data irrespective of the two number fields having any data in it?

The reason we are looking for this option is because we have two calculated fields and a third which give the sum of the two previous calculations. Now if one of the calculated field is coming up as blank, then my grand total field is also coming up as blank.

Please let me know if there is a way we can include the NVL into the calculations or if there is an alternate way of implementing the same.