assing null to currency infoobject

[former_member254358]

Hi,

is it possible to assign null (N.D and so on) value to an infoobject defined as curr type?

Some of the rows I'm uploading to BW have columns with ''  value and, they are converted to 0. I would like to keep those values not equal to 0 (equal to null).

Thanks in advance.

Regards.

[surendra_p · Accepted solution]

Hi David,

You Query is can we use NULL in place zero(0) values for key figures of type currency which having zero (0).

Answer is NO ,Because KF is of type currency it won't accept string NULL.

It throws an error while executing DTP.

Regards

Surendra

[former_member254358 · Accepted solution]

Thanks a lot, it's clear.

And it happens the same in case the ratio would be an integer.

Regards.

[Former Member]

hi David

for key figures, zero is null. if you want to save null values then create a characteristic infooobject and save those values.