variance

AndresChavez

Performing the percentage variance calculation gives me this warning An issue has occurred during processing. We are unable to complete the request at this time. What can I do to solve it or what is it due to? Thank you

GrantSmith

Hi @AndresChavez

What does your beast mode look like you're using to calculate the variance?

AndresChavez

Hello @GrantSmith .

I am using this command.

(Case when (month(`Datefield`) = month(curdate()) and year(`Datefield`) = year(curdate()) and DAYOFMONTH(`Datefield`) <= DAYOFMONTH(curdate())) then `Amountfield` end / Case when (month(`Datefield`) = month(curdate()) and year(`Datefield`) = year(date_sub(curdate(), interval 1 year)) and DAYOFMONTH(`Datefield`) <= DAYOFMONTH(curdate())) then `Amountfield` end) -1

thanks

jaeW_at_Onyx

@AndresChavez you probably have a syntax error. and your code is hard to read because you didn't format it.

keep breaking apart your beast mode into it's composite parts (the two CASE statements) and work backward until you find the point of failure.

BTW if you use three tildas , `, you can insert a code block like this

(Case when (month(`Datefield`) = month(curdate()) and year(`Datefield`) = year(curdate()) and DAYOFMONTH(`Datefield`) <= DAYOFMONTH(curdate())) then `Amountfield` end 
/ 
Case when (month(`Datefield`) = month(curdate()) and year(`Datefield`) = year(date_sub(curdate(), interval 1 year)) and DAYOFMONTH(`Datefield`) <= DAYOFMONTH(curdate())) then `Amountfield` end
) -1