Value based analysis

[Former Member]

Hi Guru's

I have a requirement to fill a column 'Value' based on column '% Units'. Where the data in the '% Units' is of the form 2.3, 4.2 8.7 and so on for respective accounts.

I have a condition that if the '% units' is b/w 0-4.9 and 5-9.9 10-14.9, 15-19.9 the values in the 'Value' column are to be filled accordingly wit pre determined values as 1, 2, 3 and 4 respectively.

Pls. suggest me how to fill the 'Value' column as such.

Thank you and appreciate your help.

[former_member183777 · Accepted solution]

Create Value as a formula that looks like this:

(% Units >= 0 AND % Units<= 4.9)1 + (% Units >= 5 AND % Units<= 9.9)2 + (% Units >= 10 AND % Units<= 14.9)3 + (% Units >= 15 AND % Units<= 19.9)4

Thanks

Vineet

[Former Member · Accepted solution]

Hi Vineet

We have a requirement that 2 KF's have to be populated during Query runtime taking date as a variable input.

So for the given dates % increase is calculated during runtime. Based on that '%Increase' the other KF "Value" has to be populated based on conditions.

Condition is that if the '% increase' is b/w 0-4.9 and 5-9.9 10-14.9, above15; the values in the 'Value' column are to be filled accordingly with pre determined values as 1, 2, 3 and 4 respectively.

Using customer exit we have written the code for the conditions and exceptions but how to get the '%increase' into customer exit to calculate Value.?

Do we need to use a BADI or a virtual KF to populate Value? Instead of using a Customer Exit.

Please help me out.

[former_member183777 · Accepted solution]

From your description, my understanding is that you already have a KF that displays the "% Increase" value correctly. If that is correct then you can implement the solution suggested earlier. If not, please explain the % increase KF. I understand that it is calculated dynamically at query runtime. As long as the KF is being calculated, you can build a query formula using it.