Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

STATUS FIELD

HI GURUS,

I i have 2 keyfigures in my report.

1 is actual & another is plan say 1.plan 2.actual.

in the 3rd column(STATUS) user want to see

if actual value is >(greater than) plan value status field should show 'achieved'.;if 0.975 plan <(less than)actuals< plan then "on target'.it should show like this.

i am giving u an example with how it should show the output.

KF1(ACTUAL) KF2(PLAN) STATUS

_______________________________

200 150 ACHEIVED

300 275 ON TARGET

150 160 ALMOST ON TARGET

THIS HOW IT SHOULD SHOW.

WE CAN'T WRITE ANY ROUTINE BECOZ THERE R NO UPDATE RULES.

ITS A TRANSACTION CUBE.

IN REPORT ONLY WE SHOULD GENERATE IT.

THANKS

SRIDHAR

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question