Last Date

[Former Member]

Hi,

I have a date field which holds many values for a combination. Now in my report, I need to show only the last/latest date value! Please help.

[Former Member · Accepted solution]

Hi Madhu,

If you want to display the latest date value then add a new selection for a structure in the rows in query designer and select your date. Now, go to the properties of the selection and change the value for "Calculate single value as" to Maximum. I hope you will get the latest value for this characteristic in the result.

Regards,

Patil.

[Former Member · Accepted solution]

It didnt work.

[Former Member · Accepted solution]

Hi Madhu,

Can you give a detailed information regarding your report. like what are the char and key figures you are using and what are you expecting in the report.

Regards,

Patil.

[Former Member · Accepted solution]

Hi Madhu,

Did you got solution for your issue. If so, please let me know how you solved that.

Thanks.

Regards,

Patil.

[Former Member · Accepted solution]

No Solution yet.

I have 'received date' and 'quantity'.

Say I received goods in the following dates:

Date Qty

1/1/2008 100

2/1/2008 200

5/2/2008 400

Now my report must show:

Last Received Date Qty

5/2/2008 700

[Former Member · Accepted solution]

Hi Madhu,

I created one report which displays the result as shown below:

______________________________

Date______________ Net sales

______________________________

7/12/2007__________696.00 EUR

11/14/2007__________44.07 EUR

12/3/2007__________130.61 EUR

______________________________

12/3/2007___________870.68 EUR

______________________________

The result row shows the recent date and total amount.

Follow the below setting for getting the output:

1. Add the date in the rows and hide the date in the properties. Restrict this data with from 01.01.1900 and to 01.01.2999. (This selection is to display only the records which are not empty).

2. Create a Calculated keyfigure with a new formula variable with the below mentioned settings:

Processing type: Replacement path.

Characteristic: DATE.

Replaced by: Key.

3.Drag and drop your new calculated key figure in the Columns. Change the properties for "Calculate result as = "Maximum"".

4. Drag and Drop your quantity key figure into the columns. Change the properties for "Calculate Result as = "Maximum"".

The above setting will display the result as specified above.

I hope this will resolve your issue. If you have any further concerns, let me know.

Regards,

Patil.

[Former Member · Accepted solution]

Hi Patil, I like your solution. Very smart.

I have the similar requirement in my report. The difference is that I want only display the lastest date and associated sales, not like what you did in the results row. Basiclly, the report display only one row, the lastest sale figures and date. Is there a way to do it? Thanks!

Tim