nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

209656_en-US

liliconcom

using Percentage Formula but i want it to show as 0.0% instead of "." or missing data only

I'm using percentage formula but the formula shows "." only when i divide 0 to 0. (0/0)

how can it show 0.0% instead?

thanks

Re: using Percentage Formula but i want it to show as 0.0% instead of "." or missing data only

Use a conditional statement in your formula and set the missing value to a zero

x = 0 / 0;
If( Is Missing( x ), x = 0 );

Re: using Percentage Formula but i want it to show as 0.0% instead of "." or missing data only

Alternatively, you could use the 'Value Label' column property:

Screen Shot 2019-05-21 at 11.38.53.png

Comments

There are no comments yet

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of