2 Replies Latest reply: Jun 17, 2015 5:16 PM by Jaswant Chowdary RSS

    Help on Assigining InputFiled value to forward records

    Jaswant Chowdary

      Hi All,

       

      I assigning new Price thorugh InputField and this value has to assigned for forward Period Unless Untill new value assigned then take that new price to take it forward.

       

      Like Below assigned 800$ start of 201910 and it is valid up to 202003 See in NewWAC Column and in 202003 entered new price 780 and it should be 780$ starting from 202003 instead of acumulated price from previous value.

       

      Can some body advice me on this aggregation.

       

      expression:

       

      If(WacPrice,WacPrice,

                       sum(aggr(rangesum(above(TOTAL inputsum(WacPrice),0,RowNo())),NDC11,Period))

      )