Error in DOMO documentation  POP: QTD QuarteroverQuarter Comparison
Hi,
I was trying to use Beast Mode that is provided here: https://domohelp.domo.com/hc/enus/articles/360043430133SampleBeastModeCalculationsPeriodoverPeriodTransforms#7.2., however the formula is not valid for Multiple Series  Previous Period. The error comes from additional ")" bracket that doesn't have corresponding opening bracket. If I remove the ")", the formula is valid, but the numbers are all wrong. I tried to place the opening "(" in few different places, but with no success.
Can you please advise how can I fix the formula?
Comments

Have you tried breaking this down and start with a table card and then create a beast mode for each of the functions and see what they return in the table card and then building it up from there? That should reveal where the error in the calculation is.
You might also want to look at a nice writeup @GrantSmith did on a flexible way to do period over period comparisons. https://dojo.domo.com/discussion/53481/amoreflexiblewaytodoperiodoverperiodcomparisons#latest
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.3 
For anyone facing this problem, here's a solution. My colleague fixed and simplified the formula:
CASE
When
(
 Check Date is in previous quarter
CASE
When QUARTER(CURDATE()) = 1 and (QUARTER(`Datefield`) = 4 and (YEAR(`Datefield`) = YEAR(CURDATE())1))
or
((QUARTER(CURDATE())1 = QUARTER(`Datefield`)) and (YEAR(`Datefield`) = YEAR(CURDATE()))) then 'T'
END
) = 'T'
AND
 check days in Q are equal
 days in CQ
(
 Days from start of quarter to Current date
DATEDIFF( CURDATE(),
CASE
When QUARTER(CURDATE()) = 1 then CONCAT(YEAR(CURDATE()), '0101')
When QUARTER(CURDATE()) = 2 then CONCAT(YEAR(CURDATE()), '0401')
When QUARTER(CURDATE()) = 3 then CONCAT(YEAR(CURDATE()), '0701')
When QUARTER(CURDATE()) = 4 then CONCAT(YEAR(CURDATE()), '1001')
END
)
)  current Q days is >= Date Q days
>=
 get Date Q days
 Days from start of Date field quarter to date
(
DATEDIFF( `Datefield`,
CASE
When QUARTER(`Datefield`) = 1 then CONCAT(YEAR(`Datefield`), '0101')
When QUARTER(`Datefield`) = 2 then CONCAT(YEAR(`Datefield`), '0401')
When QUARTER(`Datefield`) = 3 then CONCAT(YEAR(`Datefield`), '0701')
When QUARTER(`Datefield`) = 4 then CONCAT(YEAR(`Datefield`), '1001')
END
)
)
then `Amountfield`
END
0
Categories
 10.6K All Categories
 1 APAC User Group
 12 Welcome
 36 Domo News
 9.6K Using Domo
 1.9K Dataflows
 2.4K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 339 Workbench
 252 Domo Best Practices
 11 Domo Certification
 461 Domo Developer
 47 Domo Everywhere
 101 Apps
 704 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 23 お知らせ
 63 Kowaza
 296 仲間に相談
 649 ひらめき共有