Calculate Start and End date from Date field.

[Raghuvir]

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

[shrini]

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.