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" ) & ")"
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" ) & ")"
It's working as expected. Thank you so much....