Calculating % change from values in one column - Page 2 — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Calculating % change from values in one column

Received Response
383
Views
13
Comments
2»

Answers

  • EmmanuelMash
    EmmanuelMash Rank 4 - Community Specialist

    Hi Legends

    Thought I should just update you on this. With all the input you provided I decided to tackle it as below:

    To calculate the growth column, I duplicated the result column and filtered it by the minimum factor or lowest factor which as I mentioned is our starting point (Call it static result). I then summed it so that it repeats for all rows.I then used the growth formula which I typed wrong above should have been ((result - static result)/ static result) * 100.  Problem solved!!!

    Thank you all !!!

  • Can you please close the thread? (I guess "assumed answered" is the best matching as the answer is that you asked something else ...)

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    As usual love for the direct replies but none for conceptual ones dealing with understanding things :-P