Skip to main content

Hi SF Community,

I am trying to create a simple Account Level formula field but keep running into syntax problems or an error when saving it.  Here's what I'm trying to see:

Percentage of Change (+/ -) between two fields:

 

-Service Order EE Count

 

-Current EEs on Platform

 

The Formula Field is True-Up percentage. Below are some screenshots of my issue:

True Up Opportunity Formula Problem

User-added imageWhen I refresh this formula on the account level it says 75% increase rather than 25% increase. Can someone help me figure out what is causing this simple issue? 

Best,

 

-Drew 
3 risposte
  1. 22 giu 2017, 18:14

    I think you want this

    (Current_EEs_on_Platform__c - Service_Order_EE_Count__c) / Current_EEs_on_Platform__c

     

     
0/9000