Beastmode calculation error dividing

Nick_Commisso_X
Nick_Commisso_X Member
in Archive

I'm trying to create a BeastMode that will give me 'average views per user'.

(tool 1 views + tool 2 views) / total users = average views per user

 

CONCAT (

(sum(`Tool 1 Views`)+Sum(`Tool 2 Views`) / (SUM(`Total Users`)))

,'Views')

My issue is that it VALIDATES the code but then gives me the following error: "An issue has occurred during processing. We are unable to complete the request at this time". I know the numerator executes correctly and the denominator executes correctly. Just not when I divide them

 

Anyone know any potential fixes? 

Tagged:

Comments

  • ST_-Superman-_
    ST_-Superman-_ Coach 
    CONCAT (

    (sum(`Tool 1 Views`)+Sum(`Tool 2 Views`)) / (SUM(`Total Users`))

    ,' Views')

    Try this 


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • ST_-Superman-_
    ST_-Superman-_ Coach

    If that doesn't work, you could try this:

    case when sum(`Total Users`)=0 then 0 else
    CONCAT (

    (sum(`Tool 1 Views`)+Sum(`Tool 2 Views`)) / (SUM(`Total Users`))

    ,' Views') 
    END

     


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman

Categories