I have a field which calculates the % of the Opportuntiy amount is from a target amount (% from target)
I would then like to calculate this % field to show: -
On Won Opportunities, if the percentage is 90 and 100, calculate 1 %
if its between 100 and 120% calculate 2% and if its 120+ then calculate 4%. Below is what I have an it just calculates the first bit (so all results are by 1%).
IF(From_Target__c >= 90 || From_Target__c <= 99, Amount * 0.01,
IF(From_Target__c >= 100 || From_Target__c <= 119, Amount * 0.02,
IF(From_Target__c >= 120, Amount * 0.04,0)))
답변 4개
what is the return type of From Target, is it a numner or percent.
if its a number field then replace 1.2 with 120 and 1.0 with 100 and 0.9 with 90
