cancel
Showing results for 
Search instead for 
Did you mean: 

To merge 2 calculated Key Figures in a single field

Former Member
0 Kudos

Hi All,

I have two CKFs. Now I want to merge values of those 2 CKFs and display as one value in query designer. Is it possible to do so? If possible, how? Please provide me your suggestions at the earliest.

Thanks in advance,

Sananda

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

formula = CKF1 + CKF2 ?

Former Member
0 Kudos

It is summing up....i want to concatenate

brian_keenan
Contributor
0 Kudos

the key figures are units so not treated like strings, so you cannot concatonate like that

former_member202718
Active Contributor
0 Kudos

Hi Sananda,

The only solution what i can think of it, is to save the query output as Workbook,and then customize the work book as per your requirement.It will work as the workbook is nothing but Excel sheet.

Rgds

SVU123

Former Member
0 Kudos

Hi Sananda

The CKFs are numeric values, there is no direct method in BEx query designer to concatenate numbers like strings.

You may have to save the query result in analyzer as workbook and then use the concatenate function in the Excel to manipulate and get your result.

Hope this helps.

Regards,

Ninad

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Sananda,

Can you brief about your requirement becuse there is no meanig of concatination of ckfs,values also varies.As per my knowledge there is no direct function for this requirement.

Thanks,

Sai.