(IF BadVal('10YA2447') = 1 then '10YA2447.TOT' else (if '10YA2447'="RUN" THEN '10YA2447.TOT'+('chdIPES.FREQ'/60) ELSE '10YA2447.TOT')).

It generates the following error:

Error -2147219650: PI PE syntax error in Expression. [-12301] Performance Equation parsing error

Hi Ndodingam,

I tested your equation and it did work for me. However, I would recommend cleaning up your parenthesis a bit to look more like the following:

IF BadVal('10YA2447') = 1 then '10YA2447.TOT' ELSE IF '10YA2447' = "RUN" THEN ('10YA2447.TOT' + ('chdIPES.FREQ'/10)) ELSE '10YA2447.TOT'

Usually, when troubleshooting Performance Equation parsing errors, break the equation down into several terms and one remove them until you have a working equation. Once you have something that works (but is incomplete), rebuild the equation one term at a time and it usually helps catch a mistake.

For example, start with something like just:

BadVal('10YA2447') - and make sure it works, then add

IF BadVal('10YA2447') = 1 then '10YA2447.TOT' - and make sure it works, then continue on adding the next terms checking at each step that the equation still works, etc.

Hope this helps not just for this equation, but for future equations as well!

- Adam Fink