Skip to Content
0
Former Member
Apr 15, 2014 at 03:18 PM

Upgraded to SAP WEBI 4.1 - ISSUE WITH FORMULAE

19 Views

Hello All,

I have just upgraded to SAP WEBI 4.1 and used to have formulae working in the old system that do not work in the new one. The data comes out as ZERO. I did some investigation and when I used this format (IF(X=Y) Then "String" Else "String) it failed BUT!, if i used numbers instead of a string it came out correctly e.g. (IF(X=Y) Then 1 Else 2). Please see the tables below for the output I receive when I try both methods, I would like a string to show as that is the variable identifier.

Header JAN FEB MARCH 0 0 0 0 0 0 0 0

VERSUS

Header JAN FEB MARCH 1 3123413 314341353 365673 2 12345253 67865464 2325325

Please all advice and all help would be greatly appreciated. The bottom table is the green formulae that works but I cant seem to get the name because of the top table issue with strings

Nnamdi