+ Start a Discussion
MikeyOMikeyO 

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?

Sonam_SFDCSonam_SFDC

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?