amount KF with currency and number KF in one formula and folowing currency translation

[former_member268380]

Dear SCN members,

I have to calculate a formula based on an amount KF with currency (KF1) and a number KF(KF2) and then the currency translation should be applied.

Also in the same InfoProvider there is a charasteristic ZCURRENCY of type char which can be used to define currency for KF2. The meaning of KF2 is variable, it can describe an amount or just a number depending on a flag character.

Is there any way to calculate, for instance, KF1 - KF2 in a query and convert the result into a fixed target currency? Or is remodeling InfoProvider in order to organize one KF instead of KF2 and ZCURRENCY is the only decision?

To give it a try (and against common sense) I created a CKF with required calculation, for instance NODIM(KF1) - KF2, configured currency translation tab and as a result I get converted KF1 - KF2 (needed converted difference).

Thanks in advance for your advise!

[BernhardE · Accepted solution]

Dear Evgeniya,

When defining a currency conversion on a CKF then each formula component gets translated before the formula is evaluated.

According to my knowledge it is thus not possible to define a processing in the way:

(KF1-KF2) -> convert result

Instead the formula will be evaluated as convert(KF1) - convert (KF2)  (as mentioned by you..)

I am sorry that I cannot help here.

BR Bernhard