Forum Discussion
Solved
Measure return Inf
Hi ... I have below measure: Variance Projection =
VAR
_Nos = [Sum Achievement %] - [Sum Projection]
VAR
_percentage =
_Nos / [Sum Projection]
VAR
_direction =
...
You can use COALESCE to return 0 instead of blank,
Variance Projection = VAR _Achievement = [Sum Achievement %] VAR _Projection = [Sum Projection] VAR _Nos = _Achievement - _Projection VAR _percentage = COALESCE ( DIVIDE ( _Nos, _Projection ), 0 ) VAR _direction = SWITCH ( TRUE (), _Achievement >= _Projection, UNICHAR ( 9650 ), _Achievement < _Projection, UNICHAR ( 9660 ) ) RETURN _direction & " " & FORMAT ( _percentage, "0.00%" ) & " (" & FORMAT ( _Nos, "0.00" ) & ")"
Hi,
Instead of using "/" use DIVIDE function. This will avoid any issued with dividing by 0.
E.g. DIVIDE(_Nos, [sum projection])
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/
Thank you so much.