Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have expression resulting % values, I want to only show these values only>-500% and <500% , for all other values roll out values. I think,I should make it with condition expression but how should I make it for %?
Can you attach your sample file. Depending on the results you either *100 or /100.
Say your result is 45.6 then to convert to percent you *100 = 4560%
Then a simple if() will do.
Hi,
Well you can use an IF, something like this:
if($(vMyExpression) >-5 and $(vMyExpression) < 5,
$(vMyExpression)
) // Use it in your expression
-5 = -500%
5= 500%
vMyExpression = your % formula
Best Regards.
I made % values to show in chart Number tab, so it is automatically value *100.
In expression condition,
still I cant find desired results. where Act.@op is previous expression used here. Just to check values I have given 0,as I have now all values< 150%>2%
Possible to attach a sample file?
I found above will not be executed with the expression label in if statement. But it is either rolling out expression totally or showing all results. I want to display expression, however not following condition should be rolled out values.
here is the sample file...
try this for vs.OP%
=if([vs. OP YTD]/$(linPNLActualBalance_CY_YTD_BUD)<5 and [vs. OP YTD]/$(linPNLActualBalance_CY_YTD_BUD)>-5, [vs. OP YTD]/$(linPNLActualBalance_CY_YTD_BUD), 0)
and replicate it for other fields after verifying the conditions and tweaking the expression as necessary.