Forum Discussion
Solved
Rate per 1000 using 2 Excel tables
Hi all. I'm hoping someone can help me work out what I'm needing to do & that I'm posting this in the correct part of the forum. I've created a Dashboard to analyse incidents at different establ...
I don't know how to add the *1000 in the same one.
But, you could create a new measure that looks like
New Measure =(Count of incident dividedby people * 1000)
That is the only way I know how to solve that problem. Basically create a new measure and the first arguement is (old measure * 1000)
Best,
Cam
I don't know how to add the *1000 in the same one.
But, you could create a new measure that looks like
New Measure =
(Count of incident dividedby people * 1000)
That is the only way I know how to solve that problem. Basically create a new measure and the first arguement is (old measure * 1000)
Best,
Cam
Thanks Cam 😊
I never thought of doing that. It works a treat.G
