Ads

Digital clock

jom kita kawan

Friday, May 29, 2015

FORMULA FOR BASELINE % COMPLETE

Terima Kasih Allah... Assalamualaikum sahabat...

Use this formula in text1 colunm (customize field):
Int(IIf([Current Date]>[Baseline Finish],100,IIf([Current Date]<[Baseline Start],0,ProjDateDiff([Baseline Start],[Current Date])/ProjDurValue([Baseline Duration])*100))) & "%"
Select in Calculation for task and summary row: use formula


No comments:

Post a Comment