Skip to main content

Hi All,

 

Hopefully this is an easy fix for someone :

 

I’ve created a metric on IFS using Element Designer which I want to show me the total value of stock in a specific location.  The issue I have is that it’s counting everything as single items (inventory value) instead of showing the full cost if there are multiple items (Total inventory value).  When creating the metric I couldn’t see any options to count from the Total Inventory Value column.

 

Does anyone have any ideas how to achieve this please ?

 

Thankyou

 

Hi @Ian J,
 

Is it possible to share the query that you have already written?

Thanks!
Bhagya

Hi Bhagya,

 

It’s from a Saved Search:

Lobby Data Source Designer:

 

There doesn’t appear to be a Total Inventory Value column ..

 

Element Designer

 

Add a calculation in your field. Change “UNIT_COST” to “UNIT_COST * QTY_ONHAND” in the data source and you will get the inventory value.

You will have to redo the element after changing the data source. By that I mean that you have to select the Column again in the element.

Is this what you want?
 

If Yes, build the query using Advance Query and Group for Location. 

 

Add a calculation in your field. Change “UNIT_COST” to “UNIT_COST * QTY_ONHAND” in the data source and you will get the inventory value.

You will have to redo the element after changing the data source. By that I mean that you have to select the Column again in the element.

Thankyou Tomas - that now works

Terms & ConditionsCookie settings