Skip to main content
Question

Dashboard query

  • August 9, 2021
  • 5 replies
  • 123 views
I
Do Gooder (Customer)
Forum|alt.badge.img+1
  • Ian J
  • Do Gooder (Customer)
  • 3 replies

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

 

    This topic has been closed for replies.

    5 replies

    B
    Superhero (Employee)
    Forum|alt.badge.img+13

    Hi @Ian J,
     

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

    Thanks!
    Bhagya

    I
    Do Gooder (Customer)
    Forum|alt.badge.img+1
    • Ian J
    • Author
    • Do Gooder (Customer)
    • 3 replies
    • August 9, 2021

    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

     

    T
    Superhero (Employee)
    Forum|alt.badge.img+21
    • Tomas Ruderfelt
    • Superhero (Employee)
    • 500 replies
    • August 9, 2021

    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.

    AanHGTS
    Hero (Partner)
    Forum|alt.badge.img+12
    • AanHGTS
    • Hero (Partner)
    • 132 replies
    • August 9, 2021

    Is this what you want?
     

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

     

    Cheers, Aan de Silva - https://www.linkedin.com/in/aandesilva/
    I
    Do Gooder (Customer)
    Forum|alt.badge.img+1
    • Ian J
    • Author
    • Do Gooder (Customer)
    • 3 replies
    • August 9, 2021

    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 settingsAccessibility statement