I need to have a column to show Planned % Complete for a certain date that I will compare with % Complete column.
Now % Complete formula is
cstr(IIf([Duration]=0,0,100*[Actual Duration]/[Duration])) & " %"
customize Planned % Complete formula that I make is
cstr(IIf([Duration]=0,0,100*ProjDateDiff([Start],[Status Date])/[Duration])) & " %"
both formulae give me exactly same result but at task level only. However, the later one does not give correct result at summary level if I use use formula for roll-up.
I am really struggling with this, would appreciate your help. Or should I entirely follow different approach.