Print Page - Calculate Start and End date from Date field.

Title: Calculate Start and End date from Date field.
Post by: Raghuvir on 01 Sep 2014 04:38:50 AM

Hi all,

Please find the attached file for understanding my requirement.

we have 3 columns, CO Date, NSN and Invoiced Unit Price. we need to calculate the start date and end date on the basis of change in the Invoiced Unit Price.

How will i achieve this in report studio, any suggestions.

Thanks in advance.

Regards

Title: Re: Calculate Start and End date from Date field.
Post by: shrini on 01 Sep 2014 06:21:07 AM

This might be a base rough one:-

Codate=minimum(date for NSN) --Start date

case
when Codate=minimum(codate for NSN) then Invoiced Unit Price end----- min amount

case when Codate > startdate and Invoiced Unit Price is not equal to minamount then Codate end ---End date

Regards,
Srini Madhala.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Raghuvir on 01 Sep 2014 04:38:50 AM