Need to find the minimum date measure in list report

[jeeva]

Hi Techies,

I have a list report with the year, date columns and year filter. In this list, i need to show the measure value of minimum date in each row. means, i have the year data from 2015 to 2017. i need show the value of minimum date from 2015 as below.

Year        Date           xyz_col         min_date      min_date_measure 
---------------------------------------------------------------------
2015      01-01-15    100              01-01-15           100
2015      01-10-15    500              01-01-15           100
2016      03-27-16    300              01-01-15           100
2017      05-20-17    900              01-01-15           100

this is the expected result. Please suggest me.


Thanks in advance.

[MFGF]

Hi Techies,

I have a list report with the year, date columns and year filter. In this list, i need to show the measure value of minimum date in each row. means, i have the year data from 2015 to 2017. i need show the value of minimum date from 2015 as below.

Year        Date           xyz_col         min_date      min_date_measure 
---------------------------------------------------------------------
2015      01-01-15    100              01-01-15           100
2015      01-10-15    500              01-01-15           100
2016      03-27-16    300              01-01-15           100
2017      05-20-17    900              01-01-15           100

this is the expected result. Please suggest me.


Thanks in advance.

Assuming this is a report based on a relational package, you could try the following:

min_date = minimum ([Date] for report)

min_date_measure = total(if ([Date] = [min_date]) then ([xyz_col]) else (0) for report)

MF.

[jeeva]

Thanks MFGF,

It must work, But in my scenario, it is summing up wrongly. So, i used different way to achieve this using running_difference and running_total functions.

Thanks for the reply