Forum Discussion

jchen4016's avatar
jchen4016
Frequent Visitor
7 years ago

How do I Calculate the row % change when there are missing values in a Matrix

Hi I am having trouble with calculating the % difference between rows when there are empty values. 

 

My Variables are as followed:

 

C$ is the values

Countries is the different contries names

DATA_MONTH represents the time. 

 

Here is a screenshot of the data table: 

 

 

 

I used the Matrix visual, put DATA_MONTH in Rows, Countris in Columns and C$ in Values. Notice that there are some missing values here and there, how do i calcuate the row % change from here ? 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Dear jchen4016 ,

    What is the expected behavior in the columns with empty cells?

    What should a cell below an empty cell show:

    • The % change compared with the previous cell that has a value
    • No value (or a dash)
    • Infinite
    • ...

    BR

    Martin