variance

AndresChavez
AndresChavez ⚪️
edited February 18 in Dataflows


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

Answers

  • GrantSmith
    GrantSmith Indiana 🔴

    Hi @AndresChavez

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

  • AndresChavez
    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
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    @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