Forum Discussion
Inconsistent Values from PWA Custom Field Formula
Hi Bhatia,
Your formula turned out fine in my Project Desktop environment.
Try copying and pasting the formula into another custom field.
You can also try this other similar formula (copy and paste):
IIf([Finish]<cdate("7/1/24"),"FY24",IIf(month([Finish])>6,"FY" & right(year([Finish]),2)+1,"FY" & right(year([Finish]),2)))
I look forward to your comments.
Ignacio
Hi John,
Raising this once again.
As shown above, I listed my projects in Proj Professional as tasks and then applied the two formulas (one shown by your example above) and the second one that showed originally in my 11/12/24 post.
Both the formulas (when used on dates in Task view) give correct values of Completion Year.
However when I apply the same formulas to projects list in PWA, I get inconsistent values. This time I have ensured that all the projects have autoscheduled mode (i.e., no manual override date), and all the projects are Published and checked in. Yet some projects show wrong date.
As an example, the following project shows FY24 as completion date in PWA using both the formulas while the project finish date is 6/30/26. Even if consider time (5:00 p.m. vs midnight), it should either show FY25 or FY26.
Any idea, what I am missing? I mean, why formulas show different results in Professional and PWA versions?
Thanks in advance for your efforts.
Bhatia,
Sorry I can't help you with that issue. I don't have or use PWA, I strictly a Project desktop person. Hopefully someone else will jump in and field your question.
John
