Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BOXI Webi - How to Get Record Based on Max Date

Hi All,

I have a requirement for a BO report which shows the summarised data for the below data set. Currently my BO report appears like shown below.

Rate CatSupplierDateInstallationEnergised CountDe-Energised Count
T031AAA01.02.2012230000010
T035BBB06.08.201230000010
T031AAA11.03.2012240011001
T035BBB18.09.201240011010
T031AAA01.12.201260020001
T035BBB06.08.201260020010
T044BBB04.04.201260020010

I am facing 2 issues with this

1. I need to display only the records with the latest date for each  'Installation' as shown below

RATE CATSUPPLIERDATEINSTALLATIONENERGISED COUNTDE_ENERGISED COUNT
T035BBB06.08.201230000010
T035BBB18.09.201240011010
T031AAA01.12.201260020001

I have tried creating a variable v_Max, as shown below, which returns '01/01/1111' if the DATE is the  latest date for that INSTALLATION and tried to add a block level Filter to show only records with vMax = '01/01/1111' but it didnt work for some reason.

vMax = IF( Max(DATE) In (INSTALLATION) = DATE) Then '01/01/111' Else '12/12/9999'

Note: I converted 'DATE' to a Measure so that it allows me to perform the above logical test.

2.  After getting the records with the lates DATE, I need to summarise it by RATE CAT and SUPPLIER and display in the below format.(Excluding INSTALLATION)

RATE CATSSUPPLIERENERGISED COUNTDE_ENERGISED COUNT
T035BBB20
T031AA01

Any help is appreciated.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question