Forum Discussion

Copper Contributor

Nov 12, 2024

Solved

Inconsistent Values from PWA Custom Field Formula

Hello community. Greetings from first time poster. I created the following formula (“FY Project Completion”) to assign a Financial Year value based on Project Finish Date (“Finish”): if the project...

Ignacio_Martin
Nov 13, 2024
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

Ignacio_Martin

Iron Contributor

Nov 13, 2024

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

Bhatia
Copper Contributor
Nov 22, 2024
Thanks. I checked this formula in my Lab environment and it gives correct results. THANK YOU.
In my Production environment, re-published some projects and for those I got correct results. BUT there are some projects where the formula still shows blank value. Since I cannot find any explanation for that, I think I will ask my organization if we can involve MSFT through s support ticket.
John-project
Silver Contributor
Nov 13, 2024
Ignacio_Martin,
I like your approach, instead of a lengthy formula, you created an algorithm that is short, concise and will work for several years.😀
John