Skip to Content
0
Feb 22, 2017 at 02:48 PM

Langauage indepenence in EPM Excel

51 Views

Hi

We have formula's like "EPMMemberProperty(,J5,"LOCKED")" to find out a locked cost center. If cost center does not exist, excel will issue error as "#Error....". If it is a French based PC, it issues error as "#Errer....". We perform certain action based on the message i.e. #Error vs #Errer. We may have other languages too in future and I do not want to code for each language.

How did you guys handled such a requirement i.e. making your formulae language independent.?

Thanks!