Box / Object

[#1]

Hi All

I have a straight chart table showing Months Stock Holding ( which is Stock on Hand / Average Monthly Sales). (see below) I want to create a box /  object where I want to see , for eg,  Items where stock holding is less than 4 months , or Stock Holding greater than ,say 10 months.  So if i select one of these criteria, it should only show these values in my straight table.

How do i create this object / box.

kind regards

Nayan

[Anonymous]

if stockholding column is already calculated in script.

you can add one more column

if (stockholding <4,4,10) as stockholdingFilter

and then use this field as your filter .

Thanks

BKC

[#3]

Hi BKC

Thank you for your reply.  The stock holding calculation is in the front end and not in the back ground script.  Also i can create an extra column , but i prefer a box/ object ..similar to a list box.

kind regards

Nayan

[morganaaron]

You can search within a listbox using an expression that would calculate this.

If you type into the search bar of a listbox for ItemCode "=[Average]/[SOH]<4" replacing those place holders with your actual expressions, that should give you all ItemCodes that your calculation returns a value of less than 4 for.

[#5]

Hi Aaron

Thank you for your reply.  Apologies for replying late as I left for home last night.  I created a variable and here is my expression, however it does not work.  Can you tell me where i am going wrong.

if

if($(SOH)/$(Average_Sales) < 4, 'Low Stock Holding',
if($(SOH)/$(Average_Sales) > 10, 'Overstocked', 'OK'))

kind rgards

Nayan

[morganaaron]

You look like you're trying to assign values to something, which won't be working.

What I stated is for filtering the list box, so think of things such as numerical conditions or true/false statements.

If you want all your "low stock holding", you could just use the first part of your expression:

=$(SOH)/$(Average_Sales) < 4

And that should calculate and return those that are less than 4 for example.