You need to sign in to do that
Don't have an account?
Syntax error on decimal in formula
good morning,
I'm trying to create a number formula field where we rank cases based on 2 fields:
Budget__c and Queue_sort_order__c (which is another formula field)
if a budget is over 20000, then we want to calculate the number given by Queue_sort_order__c by 10% (and add it to the current value in that field), if it's between 10001 and 20000, then calculate the queue_sort_order__c by 7.5% and add to the current value in queue_sort_order_c field, etc.
if(Budget__c > 20000, (.10 * queue_sort_order__c) + queue_sort_order__c,
if(and(Budget__c > 10000, Budget__c<20001), (.075 * queue_sort_order__c) + queue_sort_order__c,
if(and(Budget__c > 5000, Budget__c<10001), (.05 * queue_sort_order__c) + queue_sort_order__c,
if(Budget__c < 5001, (.025 * queue_sort_order__c) + queue_sort_order__c
))))
but the formula is giving a syntax error on the decimal places in the formula ("." on .10, "." on .075, etc)....is there another way to express percentage in the arithmetic formula
(formula field output will have no decimal places)
thanks
put a 0 in front of the decimal: 75% = 0.75
Also, you could probably clean up your Formula a little, once you evaluate a MAX value, you do not have to re-valuate it again.
for example:
All Answers
put a 0 in front of the decimal: 75% = 0.75
Also, you could probably clean up your Formula a little, once you evaluate a MAX value, you do not have to re-valuate it again.
for example:
Thanks Stevemo,
cleaned up my formula per suggestion as well.
Thanks!