Skip to Content
0
Former Member
Jun 26, 2008 at 01:45 PM

Calculation Key Figure- Requirement

35 Views

Hi, all.

i have a requirement for a calculation key figure for a Purchasing report:

I have 4 key figures,

Column1: Material ID

Key Figure 1: current moving price for ex: 50$

Key Figure 2: highest purchasing price : 90$

Key Figure 3: lowest moving price : 35$

CKF 1: % Current moving price: (90-50)/50 * 100

CKF 2: % Lowest moving price : (50-35)/35 * 100

CKF3: Based on this above percentages, i have maintained this key figure as "" if the above percentages are below a 10% then give 1 or else give 0.

The output is working fine. But my requirement is that instead of showing 1 or 0 in the output it must show "Buy" or "Do not Buy" Now how do i implement this Text here.Please advice.

Thanks