Reporting Question

daniel_lazcano
Kilo Contributor

Hi everyone,

 

 

I am required to generate a report that compares 'start dates' on two different tables. The objective is to identify the resource plans items that are out of sync from the projects items where they are included in. That meaning, if a project is created today, there CAN'T be any resource plan items associated with that project with a start date BEFORE today. 

 

The ideal condition I am intending to achieve is the following:

 

Resource Plan.Start Date < (before) Top task.Planned start date 

 

However, the tool does not allow me to compare between two different tables, but only using conditions like 'before','after','on', a certain date like 'this year, today, last week, etc'.

 

I have tried a variety of options, even trying to implement indicator sources but I haven't found any solution

 

Any thoughts if I can achieve this?

 

 

Thank you, Danny

 

0 REPLIES 0