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]
              )

     

     

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

Waseem's avatar
Waseem
Helper III
7 years ago

Hi Anonymous

 

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

 

Cheers