Highlight misorder in Date

[rammuthiah]

I have a projects with 6 sub projects say for eg. Project1 has subprojects1, subprojects2, subprojects3, subprojects4, subprojects5, subprojects6, subproject7, subprojects8 and subprojects9

Every sub projects should have to be completed after the previous subproject.

Project,SP,FinishDate(MM/DD/YYYY)

P1,SP1,  02/02/2019

P1,SP2,  02/04/2019

P1,SP3,  02/06/2019

P1,SP4,  02/12/2019

P1,SP5,  02/14/2019

P1,SP6,  02/13/2019

P1,SP7,  02/16/2019

P1,SP8,  02/20/2019

P1,SP9,  02/22/2019

Here SP6 finished before the SP5 finish date by 1 day. So I want to highlight the subproject SP6 and Project P1.

[JordyWegman]

I've edited your sample.xlsx (see attachment) and it still works even with deleting rows and null values.

Jordy

Climber

[rammuthiah]

Please find attached screenshot, I getting mismatch while trying for the same model in my qvf

[JordyWegman]

Do you have selected all the dimensions like you have them in your data model? Otherwise it won't work correctly. Can you share that QVF that you use?

Jordy

Climber

[rammuthiah]

No. I selected for a particular dimensions. Also, I am working in hub. I tried with sample data, it's working fine, but not with real data. Is there any other way?

[JordyWegman]

You can try to include the sub project in the IF statement with the Above() function. It doesn't work with real data because you select your own variables.

Jordy

Climber

[rammuthiah]

Working except for the first row of every project. 

[JordyWegman · Accepted solution]

Good, that means we're almost there. You should create another IF with:

IF(Above(Project) <> Project, Black(), IF(.... [next one] 

Because every first one should be black of course.

Jordy

Climber

[rammuthiah]

It works!!!. Thank you so much

[JordyWegman]

Good to hear, success!

Jordy

Climber