Required restriction on charecterstics in Webi report

[venkatsk_kalla]

Hi All,

I got a requirement in Webi report, I have two charecterstics in report, example CHAR1 and CHAR2, now output of the report is as below,

CHAR1	CHAR2
AAA	aa
	bb
	cc
BBB	aa
	bb
	cc
CCC	aa
	bb
	cc

But, user required below output.

CHAR1	CHAR2
AAA	aa
BBB	bb
CCC	cc

When the CHAR1 is AAA then the output of the CHAR2 should be aa only, so what kind of settings required to acheive this in Webi report.

Thanks & Regards,

Venkat

[Former Member]

Hi Venkat,

Which Logic got work out for ur Issue? Can u plz share that logic here...

Thanks &  Regards,

Mahesh

[Former Member]

HI Venkat,

Write a formula for char2.

it would be if([char1]="AAA")then "aaa" else if([char1]="BBB")then "bbb" else "ccc".

Regards

Subbarao M

[venkatsk_kalla]

Hi All,

Realtime data is as below,

If CHAR1 is 'N' then CHAR2 should display 'thirdparty, dom' or If CHAR1 is 'E' then CHAR2 should display 'thirdpary,exp.

Like this I need to display in result.

Could you please let me know how can I write the formula in Webi report.

Thanks & Regards,

Venkat Kalla'

[Former Member]

Hi Venkat,

If([char1]="N") then "thirdparty, dom" else if([char1] ="E")then "thirdpary,exp"

Regards

Subbarao M

[venkatsk_kalla]

Thanks Subbarao, it's working

[Former Member]

Hi Venkat,

Please close the thread by selecting right answer...

Regards

Subbarao M

[Former Member]

Hi Venkat,

Could you please let us know what kind of data you will getting in the real time.

Regards,

G.SaiNath

[sateesh_kumar1]

Hi Venkat ,

Can you be a little elaborate with your real time data