TEST FUNCTION DOES NOT GENERATE CORRECT ANSWER

[curious99]

When I run this test I always get 1.3 as the result which is incorect as in some instances it should yield 1.2 or 999: what is wrong?

TEST(# SERIE mod

[John Caballero]

Hi,

Try this:

Case(

# SERIE mod

[curious99]

thanks...unfortunately it does not work i.e. the function still always brings 1.3...I wonder why as it does not make sense to me that it does not work as it is not such a complex calculation...

[BobWeaver]

This expression:

# SERIE mod

[John Caballero]

Nice one, Bob!

[curious99]

Hi again. I tried your latest suggestion but I am getting the message that that field

,# SERIE mod

[Ugo DI LUCA]

Luc,

The reason you're getting this error message is because you need to convert the " , " used in US Systems to a " ; " which is what you're using in the French Version.

Patterncount isn't Position as Position is Position. PatternCount is "Occurrences" in the French Version.

Probaly, " . " should also be converted to " , "....

If you wish to take benefit of the forums posts and have these solutions posted just pasted into yours, have a look to the sample section for a file I've made which will convert for you all these functions from French to US and vice-versa, including the " ; " trap.

Hope this helps.

And Bob was probably a bit quick in elaborating his anwer, as he forgot an AND.

So that the calc looks like :

TEST(

OCCURRENCES("p70p72p73p74";# SERIE mod

[curious99]

it works perfectly...thanks a lot to everyone who spent their time helping me find a solution, it is greatly appreciated. I like the process as I learned many new ways of looking at problem solving.

Ugo, I'll definitely try to find out the sample file you mentionned.

;-)

Luc