How do I use Fiscal Year in a Beast Mode?

Reply
Highlighted
Yellow Belt

How do I use Fiscal Year in a Beast Mode?

I've build a beast mode calculation that is not dependent on the date range field, but I can't figure out how to use our fiscal year. Note, checking the "USE FISCAL CALENDAR" option does nothing since I'm not using a date range field.

 

Here is my calcuation:

 

SUM(CASE WHEN YEAR(`ACV_Date__c`) = (YEAR(CURRENT_DATE()) - 1) AND `Opportunity.StageName` IN ('Closed Won', 'Renewal - Closed Won') THEN `TotalPrice` END)

Highlighted
Orange Belt

Re: How do I use Fiscal Year in a Beast Mode?

You need to put an ELSE statement after the THEN and before the END

Highlighted
Moderator

Re: How do I use Fiscal Year in a Beast Mode?

@ClintEagar, did rebekah's reply help answer your question? 

Highlighted
Yellow Belt

Re: How do I use Fiscal Year in a Beast Mode?

Thanks @rebekah but I don't understand how this would help...will you explain a bit more please.

Highlighted
Orange Belt

Re: How do I use Fiscal Year in a Beast Mode?

Your Statement is missing the ELSE clause.

 

SUM(CASE WHEN YEAR(`ACV_Date__c`) = (YEAR(CURRENT_DATE()) - 1) AND `Opportunity.StageName` IN ('Closed Won', 'Renewal - Closed Won') THEN `TotalPrice`ELSE 0 END)

Announcements
Coming Soon: Weekly Virtual User Meet-ups to answer all your questions! Stay tuned for more details to come this week.