Beastmode calculation error dividing

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

  • CONCAT (

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

    ,' Views')

    Try this 

  • 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

     

Sign In or Register to comment.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!