How can I created a calculated attributed based off the difference between scheduled date and baseline finish in percentage as oppose to the date difference between those two dates?
There's a similar discussion. You might have checked this one, I guess -
Have you tried this ? (Do not use the expression builder and hardcode it instead)
( DateDiff(schedule_finish,schedule_start,"Day") /
DateDiff(finish_date,schedule_finish,"Day") ) * 100
Thank you for responding, I tried the above but it stated invalid expression. At first I validated it and it worked but when you save and return it states invalid expression.
Tammi ; NJ's code just had the wrong attribute codes for the baseline dates - the technique is OK though.
DateDiff(baseline_finish,baseline_start,"Day") ) * 100
Awesome, thank you so much Dave and NJ!
I am on Ondemand and so the triggers won't help me.
Retrieving data ...