COGNOiSe.com - The IBM Cognos Community

Hi All,

I have a requirement to display the due amount based on due date.
Like Outstanding Amount, 0-30 Days Due, 31- 60 Days Due... over 365 days.
I have created a "DueDaysCount" data item and written a calculation like below..

_days_between(current_date,[Transformation Layer].[RDB_Receivable].[DUE_DATE]  )

And I have created different data items and written the case statement for 0-30 Days Due, 31- 60 Days Due,31- 60 Days,61- 90 Days,91- 120 Days,121- 180 Days,181- 360 Days, over365 days Data

Case statement for 0-30 Days Due:-

CASE
WHEN [DueDaysCount] BETWEEN -30 AND 0
THEN
[OutStanding Amount]
ELSE
(0)
END

Created "31-60 Days Due" Data item also same like above.

I am getting the correct values in the list report. But when I apply grouping, values are not summarizing.]

Could you please help me on this. Please find the attached screenshot

Thanks,
Hari

Quote from: kirru_alayam@yahoo.co.in on 01 Apr 2016 07:57:52 AM
Hi All,

I have a requirement to display the due amount based on due date.
Like Outstanding Amount, 0-30 Days Due, 31- 60 Days Due... over 365 days.
I have created a "DueDaysCount" data item and written a calculation like below..

_days_between(current_date,[Transformation Layer].[RDB_Receivable].[DUE_DATE]  )

And I have created different data items and written the case statement for 0-30 Days Due, 31- 60 Days Due,31- 60 Days,61- 90 Days,91- 120 Days,121- 180 Days,181- 360 Days, over365 days Data

Case statement for 0-30 Days Due:-

CASE
WHEN [DueDaysCount] BETWEEN -30 AND 0
THEN
[OutStanding Amount]
ELSE
(0)
END

Created "31-60 Days Due" Data item also same like above.

I am getting the correct values in the list report. But when I apply grouping, values are not summarizing.]

Could you please help me on this. Please find the attached screenshot

Thanks,
Hari

Hi,

I don't see a screenshot?

MF.

try

total (CASE
WHEN [DueDaysCount] BETWEEN -30 AND 0
THEN
[OutStanding Amount]
ELSE
(0)
END)

Hi MF,

Please find the attachment

Thanks,
Hari