Hey guys, is there a way to add the sum of 4 different currency fields (MRR, CCV, ECV, ACV) with a specified date range (x month) for each? There is a different date field associated to each currency field.
For example: (Sum:MRR from x month in Subscription Start Date Field) + (Sum:CCV from x month in Cancellation Date Field) + (Sum:ECV from x month in Downgrade Date Field) + (Sum:ACV x month in Cancellation Date Field) =
Hey guys, I am stuck on this formula, maybe you can help...I am trying to say, if the close date is not blank and if the close date is this month, then return MRR.
Check it out: IF(AND(NOT(ISBLANK(CloseDate)),CloseDate=MONTH(today())),MRR__c , null)
I am getting this error "Error: Incorrect parameter type for operator '='. Expected Date, received Number" . I am unsure on how to show a date for "this month". Any ideas?
Hey guys, I am stuck on this formula, maybe you can help...I am trying to say, if the close date is not blank and if the close date is this month, then return MRR.
Check it out: IF(AND(NOT(ISBLANK(CloseDate)),CloseDate=MONTH(today())),MRR__c , null)
I am getting this error "Error: Incorrect parameter type for operator '='. Expected Date, received Number" . I am unsure on how to show a date for "this month". Any ideas?
