How do I use Fiscal Year in a Beast Mode?

Reply
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)

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

Moderator

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

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

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.

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
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!