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])
QuickBaseCoachD
8 years agoQrew Captain
no problem,
var number DepreciationCostPerday = [Cost] / ToDays([Depreciation Term]);
Max(0, [Cost] - $DepreciationCostPerDay * ToDays([Total Days]))
var number DepreciationCostPerday = [Cost] / ToDays([Depreciation Term]);
Max(0, [Cost] - $DepreciationCostPerDay * ToDays([Total Days]))