I have to aggr the count because i am rolling up child projects of xyz to L2 and 'Programme' is the level i aggregate at. I also have to include the IF statement because there are some stragglers left behind in the rollup when i use DaysSInceLast_SteeringStatusT.
What I am trying to do though is to put the number 41 that you see in the table into a KPI (text box) but I can't figure out how to as I cannot use the IF statement
if(DaysSinceLast_SteeringStatusT =0 or DaysSinceLast_SteeringStatusT >45,....
as it doesnt relate to anything like in the table.
I tried doubling up on the aggr functions outside of the IF statement (below) but it doesnt work.