Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
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])
RyanParr
8 years agoQrew Assistant Captain
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.