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.
Quote from: Thanay on 21 Apr 2017 07:34:37 AM
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.
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