Forum Discussion

SundarKumar's avatar
SundarKumar
Frequent Visitor
3 years ago

How to achieve Difference % based on previous row value

Hi Everyone,   I have a requirement to calculate the difference (%) based on previous row value, The condition is first sort the rows based on start date, if we have two rows with same start date i...
Need Help
  • SundarKumar's avatar
    SundarKumar
    Frequent Visitor
    3 years ago

    Dear Amit,

    Thank you for the solution but small change in requirement that after sorting the rows based on Start date and lot number, we need to consider the first row as base and get the difference from remaining rows. In my example we need to consider 4.13 as base and 4.13 should come in Previous value feild and compute difference based on 4.13 value.

     

    Regards,

    Sundar