Help needed to compare two Key Figures and show out put

[Former Member]

hello experts,

I am comparing the Sales data for two year/month. I need to compare these two KF and show the result only if one is greater than the other by 40%. Sample

Jan/2008 Jan /2007

-

---

-

---

400 600

500 300

300 700

600 400

The columns should be outputted only if Jan 2008 is greater than Jan 2007 by 40% for all customers in a business area. Thank you all in advance.

Regards,

-Akash

[Former Member · Accepted solution]

Stefan,

Thank you. I did not find > function while creating a CKF.

-A

[Former Member · Accepted solution]

Hi Akash,

You will find it in the formula editor under "Boolean Operators" -> "is greater than" / >.

Hope it helps.

BR

Stefan

[Former Member]

Stefan,

Thank you very much. This solution worked perfectly.

-A

[Former Member]

Sambhu,

I have my active condition checked. Since I created this condition for the formula I created for the Over usage which should work as expected. Not really sure what is off.

-A

[Former Member]

Hi Akash,

Create your CKF like this:

(((( kf1-kf2)/kf1) * 100)>40)*((( kf1-kf2)/kf1) * 100)

This should only give you the values above 40.

Hope it helps.

BR

Stefan

[Former Member]

When you create a condition, there is a checkbox to make it active.

Please check this box so that whenever you execute it, the condition is active.

Thanks...

Shambhu

[Former Member]

Thank you all. I have successfully created a formula for the usage. But the only problem i am having is that after setting up the condition for >40, I am still seeing every result in the column meaning higher and lower. But I just wanted to see usage over 40.

[Former Member]

Hi Akash,

Your requirement could be met by

• Creating a Calculated Key Figure say variance = ( ( Jan2008 - Jan2007 ) / Jan 2008 ) *100

• Then create a new Condition on Variance so as to display rows only when Variance > 40

Hope this solves ur issue.Do revert

Vasavi

[Former Member]

Steps:

Assume that ur KF is KF1 and KF2.

1. Create a new formmula, F1 = (( kf1-kf2)/kf1) * 100

2. Create a condition.>> F1 > 40.

Unhide the result row for F1.

Thanks....

Shambhu

Edited by: Shambhu Kumar Gupta on Jan 20, 2009 10:34 AM

[Former Member]

Akash,

Create a new calculated key figure defining the overall percentage change in the 2 key figure.

Include this new calculated key fig in your columns and hide it. Create a condition on this new key figure to display only rows which are above 40%.

Regards

Shalabh Jain