Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is false in this querry (Power Play Transformer?

Status
Not open for further replies.

Julia23

IS-IT--Management
Mar 21, 2007
25
GR
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!
 
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é
 
Hi,

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

MF
 
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..
 
Halo mfgf,

Thanks for the Tip- I will try it now. Thanks both of you.
 
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
 
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top