What is false in this querry (Power Play Transformer?

[Julia23]

Halo,

I want to create a new Column and I use this Query Defination:
if ( "Datum" = 2007-01-01) then ( "Umsatz Plan 2007" * 8/ 100 ) else if ( "Datum" = 2007-02-01) then ( "Umsatz Plan 2007" *7,8 / 100)else if ( "Datum" = 2007-03-01) then ( ( "Umsatz Plan 2007" * 9,1/ 100) / 22* 12)else NULL
The Error is: (TR1112)The function used in the Expression is not valid...

I use this query in the Power Play Transformer (7.2)
Datum is a Date Value and Umsatz Plan 2007 is a numeric. I have read the Expression Editor User Guide ebook but it doesnt help! Thanks for your Help!

 

[drlex]

Is the comma a euro-equivalent of a decimal point? I see it is used twice where one might expect to see a mathematical operator or a decimal point. Could it be a locale issue with Transformer not equating a comma with a point?

soi la, soi carré

 

[mfgf]

Hi,

I'd concur with drlex -that would be my first guess too. Instead of using 7,8/100 try using 78/1000

MF

 

[Julia23]

Halo drlex and thanks for the fast answer!

Both are decimal points. I have tried it with a (.) point and with comma (,). Both doesnt work..

 

[Julia23]

Halo mfgf,

Thanks for the Tip- I will try it now. Thanks both of you.

 

[Julia23]

Halo,

I have try it but it doesnt works. Is there a problem with the else if´s or maybe with the Date? Or with the () is there a problem? I will try a new expression. Thanks for your Help

 

[Julia23]

Halo,

I have tried again and now it works. It was a simple paranthesis Error. Here the right expression:

if ( "Datum" = 2007-01-01) then ( "Umsatz Plan 2007" * 8/ 100)else( if ( "Datum" = 2007-02-01) then ( "Umsatz Plan 2007" * 78/ 1000) else ( if ( "Datum" =2007-03-01) then ( ( "Umsatz Plan 2007" * 91/ 1000) / 22* 12) else NULL ) )

Thanks for your help again!