5 Replies Latest reply: Jan 2, 2018 1:16 AM by Avinash R RSS

    Quantity and rate from different periods

    zahid Rahim

      Dear Experts,


      I have two tables one with quantities and one with rates, period and item wise. joined through composite key item+period. Now

      Sum(quantity*rate) is giving perfect result for selected period.


      I want if the selected periods dont have rates then it should pick rates from the previous period.




      Zahid Rahim