How to display only Projects w/o any Actual hours associated with them.

[#1]

I have two tables, one that has Project Data: Name, PorjectID, StartDate, EndDate... And the other with ActualHours for the time period of the Porject.

I am looking to display only the Projects with no ActualHours in an Audit page.

I am thinking I need to load the table and add up all of the ActualHours and then do a conditional on the total to only display ones with 0.0 as their total?

Just not sure how to do that.

[#2 · Accepted solution]

Try this !

I think there's a way to show what you're expecting with the aggr function.

I'm gonna see 😉

EDIT : You can get the values by creating a list box, <Expression>

"=if(isnull(Achieved),Name)"

[#3]

Based on the assumption that ProjectID is a unique key you could put it as dimension and then have one of the fields in the table as an expression. In that expression you do =if(ActualHours='',StartDate). Then only projects without ActualHours related to it should show up in the table.