Forum Discussion
lawada
Helper III
4 years agodivide function returns 0 instead of number
hello i have a measure where im dividing two measures numinator : [active users 30 days ago]-[active users prevoius 30 days ago] denominator :[ active users 30 days ago] both measures im usin...
- 4 years ago
Hi,
It is likely the result is just too small (0,0035350764917413) and because you use two decimals to display your results the value shown is 0,00. So just add decimals and you should be good to go.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
VahidDM
Super User
4 years agoHi lawada
Try this:
MOM=
Var _A = [active users 30 days ago]-[active users prevoius 30 days ago]
return
divide( _A ,[active users prevoius 30 days ago])
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
- lawada4 years ago
Helper III
still not calculating properly, returing 0