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