Calculating percentage

Hello,

I am trying to display a percentage of an item., like :
~ Remaining Inventory % = The remaining inventory/capacity percentage of 250 items.
~ Remaining Inventory Count = The remaining inventory/capacity number (this would display the remaining capacity left.
(which will be 250 - Current Item Count)

but I can’t do the expression of "250 -" before adding a data to calculate the current item count that I have.

for the remaining inventory % im getting "-96.4" instead of just "96.4"
and for remaining inventory count I can’t get any data properly because I can;t add 250 - before the data.

There’s a few option
A) add *-1 at the end of your expression, this will turn it into positive
B) Use Arbitrary text:format as number (set 250 un your arbitrary text)
C) Use a custom state type number and set it by default at 250, use this custom state value first

And there’s probably a lot more that I forget…


still nothing, unless I did it wrong..

Why do you have -100? and search for items / 250 shouldn’t create a negative number.
This formula is not like you said in your OP.

You didn’t talk about divided by 250 but substracted by 250

I am doing a percentage calculation.

which is "Search for items:count / 250 * 100" which currently gives me -96.4 instead of 96.4.
96.4 is the un-used inventory and 3.6% is used inventory.

im trying to find the % of remaining inventory

The first thing you should do is activate parenthesis feature (in settings, versions)
You should be good after that to set correctly your expression by placing each part in the correct order (for that ,select the relevant “more” after parenthesis)
Also, in your screenshot, you didn’t do * -1 (this is what will make your negative a positive number)

I’ve done that but no idea how to calculate what you said…

still getting the -96.4

Can you show what you have?

nevermind…thanks it worked.

do you by chance know how I can calculate over-stock?

so if items exceed 250 items, another thing that I have made, will count up. so if current items reach 260 the count will show 10 as over stock

In a different calculation you mean?
like Search for stock-250 > 0 :format as text ( first box: do a search for stock -250, second box 0)

it shows as a yes/no for formatting

Don’t forget the :format as text part
(and I forget to add :converted to number)


not sure if I did it correct

Now in formatting as text yes box, do Search for count -250 , on no, set 0

thanks!

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.