10 Replies Latest reply: Feb 24, 2016 8:24 AM by balraj ahlawat RSS

    To find the units of stock when we know the quantity and units sold

    Anuraj kokkeragadda

      Hi ,

       

      In my scenario, explaining briefly a car owner have a particular model 140 cars and when a customer purchased the no.of cars remaining will be 139.So for the next customer i have entered quantity as 139 in fact table .Like wise i have entered reducing the quantity for 1300 customers .So if i want to find the total quantity it was adding total the 140+139+138 of the same car which was giving wrong result.So its difficult to find the units in stock.Could anyone suggest an expression which gives only the remaining quantity  of that particular car.

       

      Pls help me if you know this

      regards

      Anuraj