cancel
Showing results for 
Search instead for 
Did you mean: 

Reverse sign on amounts - how to achieve this?

Former Member
0 Kudos

Hi,

The requirement is to convert the actual + amount to Reverse sign only for particular items against the key figure. How can we achieve this?

I appreciate your help.

Thanks,

BW USA

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

can you identify your particular items with a characteristic value (e.g. ITM_TYPE)?

if yes then, assuming you want to reverse the sign of KF form ITM_TYPES A and B

- Create a selection (S_REV_KF) with KF and ITM_TYPE = A OR B.

- create a formula RESULT = KF - 2 x S_REV_KF.

other possibilities: create a hierarchy with reversed sign nodes, structure (only if very few "items"... also possibility to add a nav attr attribute to your "item" in order to restrict more easily your S_REV_KF....

finally post the result with the logic in your cube via URules....

hope this helps....

Olivier.

Former Member
0 Kudos

Hi Oliver Cora,

Our Item name is 0CS_ITEM.

We have added all hierarchies under the 0CS_ITEM. Please help.

Thanks

Former Member
0 Kudos

Hi,

for how many items do you want to reverse your KF?

Former Member
0 Kudos

Thanks for all your message,

We also have 0CS_ITEM.

Former Member
0 Kudos

We need to reverse all the 14 items relevant to Liabilities...

Thanks.

Former Member
0 Kudos

ok,

then proceed as I explained in BEx:

- a selection with KF and 0CS_ITEM restricted to your 14 items

- then a formula = KF - 2x <the above selection>; this should be your result.

hope this helps,

Olivier.

Former Member
0 Kudos

Thank you very much for your expert comment.

I have assigned the points to you..Thanks again.

Answers (1)

Answers (1)

dielom
Active Contributor
0 Kudos

Hi,

You can do this in the update rules. You can make a routine checking for those particular items and multiplying it with -1.

Hope this helps.

Regards,

Diego

Former Member
0 Kudos

Thanks Diego.

We required this set up for BCS report especially for all the liability account items.

Can you please explain how to achieve this? Thanks.

The query is being created on virtual cube..Just for your information please.

Message was edited by:

BW USA

Former Member
0 Kudos

Is there any way to do it at query level? Thanks.