I'm having a specific financial KPI field that is calculated by this formula;
((Total_Platform_Value__c / Contract_Length_of_Platform_LicenseOPPTY__c ) * ( Last_Day_current_Year__c - Contract_Start_Date_Platform__c))
+
Total_Solutions_Value__c
Normally there is a total platform value and a total solutions value, so both values are available. But in certain special cases, I only have "solution values" which then solely counting towards my final financial KPI.
So how can I specify (adapt the current formula), that if the platform value is 0 or not existent then it should just take only the total solution value for the calculation. Meaning only the total solution value equals my fincanial KPI.
Right now as soon as I dont have a platform value, the formula is not working, meaning it says
#.Error!
Thank you very much for your help,
Philipp
8 Antworten
ah yes sorry actually the "Contract_Length_of_Platform_LicenseOPPTY__c" is as well 0
so how can we reformulate the formula that if (scenario) the Contract_Length_of_Platform_LicenseOPPTY__c is 0 or not existent then it should only take/consider the
"total platform value" + "total solution value" for final value.
if "contract lenght" and "total platform value" are 0 or not existent, then it's only "total solution value" for final value.
but if there is a "total platform value" and a "contract lenght" value then it should do the full calculation as above statet in my formula....
Thanks,
Philipp
