Compare fields in set analysis

[#1]

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

[#2]

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!