Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have 2 fields in my table : Project Completion Date and Project due date. Now I need sum of all rows for which the Project completion date > project due date. I tried using the following set analysis but it didnt work.
=Sum({1<[PPO Indicator] = {Close},[Project Status] = {Completed},[Project Completion Date]={">=$(=[Project Due Date])"} >}[Value])
The user does not select any values in these fields.
Thanks
Arun
It's not really clear, but I think this is the wrong part:
[Project Completion Date]={">=$(=[Project Due Date])"}
If I understand correctly, you use a dollar sign expansion without reason, IMO.
It should be [Project Completion Date]={"=([Project Completion Date]>=[Project Due Date])"}
This (should) select the rows having PCD greater than PDD.
Hope it helps!