Maximum Date

[#1]

Dear all,

i have date wise sale qty. how can i find sales qty with maximum date.

Regards,

Masba

[anbu1984]

=Firstsortedvalue(Qty,-Sales_date)

[#3]

In case you want in Text box , you can use set expression i.e. sum({$<Sale_Date ={$(=max(Sale_Date))} >}Qty)

[morgankejerhag]

How will you be using the value? If it is in a table with Date as a column then you could do:

if(Date=max(total Date),sum(Qty),0)

See attached example

[#5]

hey masba,

vSaleDate=max(sale_date)

=only({<sale_date={"$(vSaleDate)"}>}qty)

cheers,

kunal bhattacharjee

[jagan]

Hi,

Check this expression

sum({$<Sale_Date ={'$(=Date(Max(Sale_Date)))'} >}Qty)

Note: Sale_Date and Today() date format should be in the same format.

Regards,

Jagan.

[ashfaq_haseeb]

Try this

=sum({$<Sale_Date={'$(=max(Sale_Date))'} >}Qty)

Regards

ASHFAQ

[#8]

Dear Morgan ,

Thnx for ur reply.. your suggestion is working simple table .. but my problem is that in my chart X axis will display maximum date and Y axis will show sum(qty)..

Regards,

Masba

[ashfaq_haseeb]

You can change the chart type?

What chart type are you using?

Regards

ASHFAQ

[#10]

assign max(sales_date) to a variable then only{$ <Vsals_data>qty}