Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Inventory Value

Hello!   I am currently working on a report with data from an older version of NAV to display infromation about the inventory but I've hit a snag when it comes to displaying the current inventory v...
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    you need to relate your tables:

     

    and then the measures are easy

     

    RemainingQuantity = SUM( Transactions[Quantity] )

     

    Value =
             SUMX(
                     Items,

                     [RemainingQuantity] * Items[UnitPrice]
              )

     

     

LivioLanzo's avatar
LivioLanzo
Icon for Solution Sage rankSolution Sage
7 years ago

Anonymous

 

please post a sample of your data along with expected results

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sample Data:

No | Description | UnitPrice
10  | Adapter |99

 

Entry No | Item No | Quantity | Remaining Quantity
1 | 10 | 1 | 1
2 | 10 | -1 | 0

3 | 10 | 2 | 2

 

Goal:

 

No | Remaining Quantity | Value(Remaining Quanitity * UnitPrice)

10 | 2 | 198

  • LivioLanzo's avatar
    LivioLanzo
    Icon for Solution Sage rankSolution Sage
    7 years ago

    you need to relate your tables:

     

    and then the measures are easy

     

    RemainingQuantity = SUM( Transactions[Quantity] )

     

    Value =
             SUMX(
                     Items,

                     [RemainingQuantity] * Items[UnitPrice]
              )

     

     

  • Waseem's avatar
    Waseem
    Icon for Helper III rankHelper III
    7 years ago

    Hi Anonymous

     

    Please share your sample table. that would be efficient way to find a solution for you.

     

    Cheers

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hello Gandalf, 

     

    If you want to calculate inventory value you should calculate that from the Value entry table. It's more accuarate than the item table. 

    / J