Data TypeFormula
Decimal Places0
( SBQQ__NetTotal__c * (1+ SBQQ__Quote__r.Financing_Rate__c)) / SBQQ__Quote__r.Financing_Term__c
if the Financing Term field is a picklist. I thought about making a hidden field with a workflow rule to update it and using the hidden field in the formula but don't know how to write the formula for the WFR. I need to be able to say if the finance term field contains 60-months put in 60, if it says 90-months but in 90. Im hoping that if I can do that then I can use the hidden field in the formula unless someone can tell me how to write the above formula to work with a picklist filed. Whats my best option here?
11 answers
Why even have a field then? Why not just hard code 0.0699 into the Formula?
