Skip to Content
0

C4C reporting exchange / map values (avoid # / hashtag)

Aug 11, 2017 at 08:05 AM

91

avatar image
Former Member

Hello experts,

I've got the # ( hashtag-sign) in my report and view other values, which I want to "exchange" or "map".

This is the original data.

now let's say. I want to exchange the value for column Gender like this:

1 = m

0 = <empty> (No # hashtag-sign)

2 = f

it should look like this afterwards

Does anyone know what is the best way to perform it?!

Thanks

Nik

screen01.png (108.5 kB)
screen02.png (109.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Varaprasad Raju Potturi Aug 14, 2017 at 04:05 AM
0

Hi,

You can try as follows :

Convert Grid Display to Excel Table Display

Just key in Excel formula in last column of the report result as

=IF(F3="1","M",IF(F3="2","F"," " )) *assumption F3 is Gender column

This formula will be auto adjusted to all rows.

Thanks,

Raju

Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Raju,

just to make sure I understand you correctly.

You suggest to do it in Microsoft Excel, after "saving the report as file"?

If so, well that's exactly what we want to avoid.

0

Hi,

Convert Grid Display to Excel Table Display - this is not saving the report as file.

Once you convert to Excel Table Display your excel formula automatically recognized based on query result.

Thanks,

Raju

screen-dump.png (36.9 kB)
0
Former Member

Hi Raju, thx for your answer.

The issue is still, that the customer wants to see "M"-value or "F"-value in SAP C4C, not in excel.

So let's say, we are not allowed even to think about using Excel, when looking for a solution of my question :=)

Is it possible to do it somehow with key figures?!

0

Hi,

I don't think this is possible in web reporting.

Thanks,

Raju

1
avatar image
Former Member Sep 04, 2017 at 04:13 PM
0

So far, it seems like it is NOT possible to implement my requirement. Any other ideas @experts???

Share
10 |10000 characters needed characters left characters exceeded