Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have the following set analysis expression:
Sum({<OrderDate={'>=01/01/2012'}>}SalesAmount)
How can I add a <= 10/01/2012 to this set analysis?
So the sales should be focused on this date range.
I tried:
Sum({<OrderDate={'>=01/01/2012' '<=10/01/2012}>}SalesAmount) and adding a 'and' to the expression but it didn't work.
Sum({<OrderDate={'>=01/01/2012 <=10/01/2012'}>}SalesAmount)
no quotes inside SA
Try Sum({<OrderDate={'>=01/01/2012<=10/01/2012'}>}SalesAmount)
Try
Sum({<OrderDate={">='01/01/2012'<='10/01/2012'"}>}SalesAmount)
Double quotes for the search and single quotes to prevent QV from interpreting your date as a division.
Hi
Try
This
Sum({<OrderDate={'>=01/01/2012<=10/01/2012'}>}SalesAmount)
Hi John, are you able to achieve ?
Hi,
Try like this
=Sum({<OrderDate={'>=$(=MakeDate(2012, 1, 1))<=$(=MakeDate(2012, 10, 1))'}>}SalesAmount)
OR
=Sum({<OrderDate={">=$(=Date(MakeDate(2012, 1, 1), 'MM/DD/YYYY'))<=$(=Date(MakeDate(2012, 10, 1), 'MM/DD/YYYY'))"}>}SalesAmount)
Hope this helps you.
Regards,
Jagan.