Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Measure issue

Hi All,   I have a matrix where rows are different cost types, the column has months from January to December, the values is the amount which is of two types either forecast or invoiced. Filters ap...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Mahesh,

 

Thankyou for your help but this is also turn the 0 in 2022 sky blue which I dont want. I want 0 in 2022  as green since it is invoiced. 

Mahesh0016's avatar
Mahesh0016
Super User
3 years ago

Anonymous 

 

 

**If this post helps, please consider accept as solution to help other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Mahesh,

     

    Thanks again but I understand in my data some of the item types are blank because of which is it still considering 0 as green for the future years like 2023 & 2024. I tried both your solutions they din't work can you help me with a formula where if the item is blank and year is greater than 2023 it should be blue.

     

    Thanks in advance 🙂