Skip to Content
0
Former Member
Oct 31, 2012 at 09:10 PM

Incorrect totals in webi report

203 Views

I am using BO 3.1 against SAP BW .

In my report, I can create a table based on a string date field called [Query 1].[L01 Cal. year / month] with the format of "09.2012" for a value. I am able to put

this field in a crosstab and have it display the correct total for each month.

But, now, I need to remove the crosstab part and just display a total for the previous month.e.g. September 2012.

I am able to use the following formula and get the correct result.

Sum([Units] ForEach([Facility])) Where ([Query 1].[L01 Cal. year / month] ="09.2012")

But, I obviously have to hard code the month-year value.

When I try to use the field in the formula instead of hardcoding it, it returns the total for all of the months in the year..See below...

Sum([Units] ForEach([Facility])) Where ([Query 1].[L01 Cal. year / month] = Last(Query 1].[L01 Cal. year / month]))

I have attempted to use Trim,and Substr functions,and to also convert the values to an actual date value, but to no avail.

Any help with this formula would be greatly appreciated !

Thank You.