Can a formula ever use different field types?
I?m trying to put a Remaining Depreciation formula together, but it uses a duration and a currency field. From what I've seen, using two different field types in a formula does not work. Is there ...
Forum Discussion
Re: will the two different field types never work in a formula?
In fact, two different field types can always work in a formula because there are a whole set of function to convert from one field type to another.
Try this.
var number DepreciationCostPerday = [Cost] / ToDays([Depreciation Term]);
[Cost] - $DepreciationCostPerDay * ToDays([Total Days])
In fact, two different field types can always work in a formula because there are a whole set of function to convert from one field type to another.
Try this.
var number DepreciationCostPerday = [Cost] / ToDays([Depreciation Term]);
[Cost] - $DepreciationCostPerDay * ToDays([Total Days])
- Is it possible to prevent the value from going below zero? Once the Remaining Deprecation value hits $0 it would stop calculating (or something like that) etc.
- no problem,
var number DepreciationCostPerday = [Cost] / ToDays([Depreciation Term]);
Max(0, [Cost] - $DepreciationCostPerDay * ToDays([Total Days]))
