Forum Discussion

natasha519's avatar
natasha519
Helper II
4 years ago
Solved

Calculating Percent Change

I have a table with 4 columns as shown below: I also created 2 calculated columns which a) gives me a 1 for the LatestDate in the dataset (April 2021) and then b) gives me a 1 for the LatestDa...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi natasha519 

     

    If I understand correctly, you only look at the MaxDate and MaxDateMinus1Year, then you want to put the values and percent change in the same matrix? Here is one way, file attached

     

    I got the dummy data, 

    created a new table as the custom column

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi natasha519 

 

If I understand correctly, you only look at the MaxDate and MaxDateMinus1Year, then you want to put the values and percent change in the same matrix? Here is one way, file attached

 

I got the dummy data, 

created a new table as the custom column

 

natasha519's avatar
natasha519
Helper II
4 years ago

It seems to be working, but is there any way to format the column headers as April 2020 and April 2021 instead of m/d/yyyy?

Also how can I format the values to not be decimal and just whole numbers?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi natasha519 

     

    Yes, FORMAT the date

     

     

    • natasha519's avatar
      natasha519
      Helper II
      4 years ago

      Thank you so much!! Do you mind explaining to me what you did so I can learn for my own self please?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi natasha519 

         

        I was creating a custom column for the Columns in Matrix, the use SWITCH to do different calculation (or call different measures) as you wanted to calculate different values in the same matrix...