cancel
Showing results for 
Search instead for 
Did you mean: 

Which way is better to reverse a key figure sign, update rule or KF prop.?

Former Member
0 Kudos

We are trying to reverse a key figure sign and have got two options:

1. In Update Rule by using formula to make this key figure * 1-, or

2. In key figure property of query design mode, there is a checkbox of "Reverse +/- Signs".

Which one is better for the above two options?

Thanks

Message was edited by: Kevin Smith

Accepted Solutions (1)

Accepted Solutions (1)

former_member188325
Active Contributor
0 Kudos

Hi,

Using this property in Qurey level for that particular Query only....

again that depends on Requirements also...all users may not want to have this...so in this case do it in Query level..

If all users need this option,the do it in update rules.

Thnaks

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

This depends upon how you are using them for reporting. From my eperience I suggest you to do this in Query. You can even use new formula for this. i hope this iwll help you.

former_member181964
Active Contributor
0 Kudos

Hi,

1. In Update Rule by using formula to make this key figure * 1-, or

A: If you want to update data permanently in Data Targets then go for update rules.

2. In key figure property of query design mode, there is a checkbox of "Reverse +/- Signs".

A: The data is not updated in Data Targets but while displaying in Reports it will display the sign.

That is upto you and business requirements.

Thanks

REddy

Former Member
0 Kudos

Hi,

Option 2 leads to more time consumption at query execution than option 1 , enethough it is insignificant.

With rgds,

Anil Kumar Sharma .P