Beastmode calculation error dividing

Nick_Commisso_X

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? 

ST_Superman

CONCAT (

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

,' Views')

Try this 

ST_Superman

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