Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
The vlastmonth is a variable used to compute total. My question is how to get only the very latest date and its corresponding ie
25/09/2014 5,244.31
Tried to use the firstsortedvalue(amount,-Date) but returned null.
Please help
firstsortedvalue(Distinct amount,-Date)
Hi,
you can use the below to get sales on latest date.
sum({<Date={'(=$(Max(Date)))'}>}amount)
Hi Joe,
For the vLastMonth the last transactional date is 25/09/2014 not the the 30/09/2014 as we all know. The requirement is to display the amount for the last transactional date.That is where my challenge layst.
Manish and Shruthi I didn't get the desired results.
So how can I get the max date from the vlastMonth variable
How have you defined vLastMonth? Should be able to just Max() on that to give you the date then
vLastMonth=Month(date(AddMonths(max(Date), -1)))
Perhaps it's the date format?
hello
if you mean by that you want the maximum date and its corresponding amount no matter what the active selection is you could create a variable for example vDateMax et put the following in it
=date(max({1}Date))
this will give the latest date no matter the selection and to get its corresponding amount
=only({<Date={"$(vDateMax)"}>}montant)
other wise to get the latest date and its amount , taking into account selections, you need to put =date(max(Date)) in
vDateMax .
See if it helps
Regards