zero value

[beck_bakytbek]

Hi Folks

i have a question, i am using this expression:

num# (Einstandspreis, '#.#', '.', ',') as Einstandspreis

i have some ZeroValue, but i am not able to convert these zero values into 'no values'

does anybody have any idea how to resolve this issue

Thanks a lot

Beck

[big_dreams · Accepted solution]

can you explain with sample data??

try like

Replace(Trim(Replace(fieldName,'0',' '),' ','0') as newFieldName

Regards,

[Ivan_Bozov]

Maybe this: If(Einstandspreis>0, YourExpression) as Einstandspreis

[felipedl]

Hi Beck,

Not quite sure I understood, but you want to have null values when the value of your Einstandspreis is zero?

If so, you can use a conditional on your load statement, like this:

Table:

Load

     if (num# (Einstandspreis, '#.#', '.', ',')>0,num# (Einstandspreis, '#.#', '.', ','),null() as Einstandspreis

From [Whatever];

If your number interpretation is greate than zero, it will input null as "value".

If I misunderstood your problem, please add more to it and i'll try to help.

Felipe.

[beck_bakytbek]

Hi Felip,

i am using this expression:

num# (Einstandspreis, '#.#', '.', ',') as Einstandspreis

and i want to replce zero-values with 'no value' and this is my problem

[big_dreams]

can you explain with sample data???

Regards,