I'm trying to get my reps monthly target attainment % and need a formula that goes
IF date of subscription start is in October then Net MRR / monthly target but I'm getting a bunch of error messages.
Thanks for your help!
4 answers
PS. You don't need an IF around the CASE function, also you need an Else result like this
CASE(MONTH(Opportunity.Date_of_Subscription_Start__c),
7,44000,
8,40000,
9,60000,
0 )
