Skip to Content
0
Former Member
Jan 16, 2012 at 03:52 AM

How to Use Backslah() in webi report formula

342 Views

Hi

My client is using web intelligence XI 3.1 SP2. I have a formula in a report as:

=Sum(If([Level 08 Node] InList ("Correlation & Index";"EM\FX Option JV";"Short Dated Exotic Options";"Long Dated Options";"Short Dated Vanilla Options";"Options");[SR MTD];0))

Everyime I save the the formula I am loosing the "\" in the "EM\FX Option JV", so the formula becomes:

=Sum(If([Level 08 Node] InList ("Correlation & Index";"EMFX Option JV";"Short Dated Exotic Options";"Long Dated Options";"Short Dated Vanilla Options";"Options");[SR MTD];0))

how can I use the backslash in the above formula , I appreciate that it is a special character.

Many Thanks