This content has been marked as final. Show 5 replies
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.