Constant value in one field in the Bex Report

[Former Member]

Hi,

I want to have a field where the value of it constant irrespective of corresponding fields values.

Please suggest and let me know how to do it.

Regards,

Prem

[Former Member]

Hello,

Make a local formula in the Query & enter your required constant value in that formula. It wont change as per any drill down.

-Shilpi

[Former Member]

Hi,

If you have any logic in your mind to populate that extra char or key figure , then you can make use of virtual char & virtual keyfigure .

Or if you want to just pass any constant value, then in CKF make a formula variable with user entry . What ever user enters in the selection screen that will start appearing in the report output against all the rows.

Hope the above reply was helpful.

Kind Regards,

Ashutosh Singh

Edited by: Ashutosh Singh on May 12, 2011 8:55 AM

[anshu_lilhori]

Hi,

Please elaborate your requirement for better understanding.

I guess you can make use of constant selection if you want the values to be constant irrespective of any changes in other column values.

Hope it helps.

Regards,

AL

[Former Member]

Add a local formula and enter the constant value in formula