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.

       

      Regards

       

      Zahid Rahim