You need to sign in to do that
Don't have an account?
JaxBeach
How can I do an Annualized Sales formula in Salesforce?
I have the formula in Excel, I just don't know how to convert it so Salesforce recognizes it.
The Excel formula is
((YTD Sales / (365- (DATE (2013,12,31) - TODAY ()))*365))
Thanks :-)
Do you have a field in Salesforce at the Account level that captures YTD Sales? If so, you just need to use this formula to replicate your Excel one:
All Answers
Do you have a field in Salesforce at the Account level that captures YTD Sales? If so, you just need to use this formula to replicate your Excel one:
It worked! Thanks for your help with this :-) much appreciated