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