You need to sign in to do that
Don't have an account?

Validation Rule - Don't allow change to Formula Field once value is in place
I have a formula field that gives me a Avg. Revenue Per User (ARPU). This is done every month beginning in January and ending in December.
It divides total monthly revenue / total number of subscriptions.
So for instance.
On January 30 the account billed $100 and had 100 subscriptions : ARPU = $1
If I don't lock this formula field, once I add the next month subscription the ARPU for January would change. i.e.
On January 30 the account billed $100 and had 100 subscriptions : ARPU = $1
On February 28 the account billed $110 and had 110 subscriptions : ARPU = $1
but then January would calculate wrong,
January would look at the $100 billed in January and divide by 110 subscriptions (the new total number subscriptions): ARPU = $0.91
and this ARPU number would continue to decline as the subscriptions grow.
This is caused by the subscription number changing from month to month.
Any ideas on this?
Reading the issue, I think the calculation of ARPU should be total monthly revenue/total monthly subscriptions(instead of just total number of subscriptions)
Both these fields should be date dependent - can you please share the exact formula you are using to calculate the ARPU in your ORG?