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 0VERSUS
Header JAN FEB MARCH 1 3123413 314341353 365673 2 12345253 67865464 2325325Please 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