July 19, 2016
Hello, I am having an issue with displaying my data -- it looks one way on the data tab and a different way on the scoreboard tab when it is included as part of a text string.
Step 1 : On my data tab I create a calculated value
KPI= Variable1 / Variable2
and set the formatting to a number with no decimal places.
The formatting works as expected on the data tab, for example, a KPI of 83 shows up as 83.
So far so good, so I create a named range to reference this cell later.
Step 2 : On the scoreboard tab, I created a cell that contains a text that is structured as
= "KPI: " &KPI & "%".
So the happy path would be a visual display of
Instead, what is displayed is
Not a problem, so I think, I just need to change the formatting on the scoreboard tab to match.........however changing the formatting is not working. I've tried General, Number (0 decimal places), and Text, and when the KPI percentage is a fraction, it displays out to something like 10 decimal places. And,not to get too technical, looks really really dumb.
June 25, 2016
July 19, 2016
Thanks for your quick response. Using the TEXT( ) function worked.
The other solution that I came up with was when I remembered that formatting only impacts how a value is displayed, and not the underlying value.
That's what the ROUND( ) function is for, so if I define and name the KPI formula as = ROUND ((Variable1/Variable2)*100, 0) the KPI will always be a whole number.
Solution 1 is most likely the preferred solution since the .3333333333 might be important in other calculations.
Most Users Ever Online: 57
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Rachid Si Salah
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas