To calculate the rows dynamically RRS feed

  • Question

  • Hi,

    I am stuck up while re-computing the value of a field in my report.

    I need to adjust the value for the field On hand in the current week as per the previous week's cumulative total value(Demand+Inbound Supply+On Hand).

    As an example

    Week 47:

    On Hand = Total of previous week(46) = 557.72

    Week 48:

    On Hand = Total of previous week(47) = -993.83

    Similarly for the other weeks as well.

    Please find the screenshots for the same below.

    Also as we are adjusting the value for on hand field then the cumulative total will also get updated accordingly.

    Any help will be greatly appreciated!!

    I need to implement this in one of my report urgently.

    Tuesday, November 14, 2017 1:50 PM