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!
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!