MS Project calculation help

Question

Hi,

I'm currently doing a MS Project Beginners to Advance course on YouTube.

My issue is, we are doing a relatively simple calculation. The calculation is to create Red, Amber, Green flags for variances in costs.

I am using their example sheets, therefore should not be any issues relating to missing fields - at the very least.

I have copied their calculation verbatim per the course and it does not work.

The calculation is:

IIf([Cost Variance]>0, "X", "G")

What it is saying is:

if the cost variance is greater than 0 - if true, output an "X" for positive values.

For the G - if false, the cost variance is negative then output a "G".

I get the below error pop up every time and don't understand why?

"The formula contains a syntax error or contains a reference to an unrecognized field or function name."

Thanks

Answer 1

Well, that works for me in a text field. Is your formula in a custom text field?

In your country version of MSP maybe the quotes or comma separators should be other characters. Try single quotes.

Answer 2

Hi Trevor,

Thank you.

I changed the comma separator - to works now.

Much appreciated.