Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want to create this expression:
If Status = {'A'} and Received_date_field > vSelectDate and Invoiced_date_field < vSelectDate , Count (StockID)
vSelectDate is a variable : Max(Received_date_field)
Please need help emergency
Thanks
Hi,
Try this expression
=count({<Status = {'A'}, Received_date_field={'>$(=Max(Received_date_field))'}, Invoiced_date_field={'<$(=Max(Received_date_field))'}>}StockID)
Hi,
Try like this
Count({$<Status = {'A'},[Received_date_field]={">=$(vSelectDate)"},[Invoiced_date_field]={"<=$(vSelectDate)"}>} [StockID])
Make sure you have proper date format.
Regards
ASHFAQ
Thanks but, i want , if i select the month exp: March 2013 without selecting the date it give me 31/03/2014.and i need all data from 2008 till the date who i selected.
Hi,
Option 1: = monthend(max(Date) )
Option 2: = monthend(makedate(Year, Month) )
Regards
ASHFAQ
This is my expression: i need all data from 2008 till the date who i selected.Can you give me the full expression please.thanks
Count({$<Status = {'A'},[Received_date_field]={">=$(vSelectDate)"},[Invoiced_date_field]={"<=$(vSelectDate)"}>} [StockID])
Variables: vStartDate : 31/12/1988
vSelectDate: Max(Received_date_field)
vMonthEnd: MonthEnd(Received_date_field)
Hi,
Can you post sample app with expected o/p
Regards
ASHFAQ
This is my expression: i need all data from 2008 till the date who i selected.Can you give me the full expression please.thanks
Count({$<Status = {'A'},[Received_date_field]={">=$(vSelectDate)"},[Invoiced_date_field]={"<=$(vSelectDate)"}>} [StockID])
Variables: vStartDate : 31/12/1988
vSelectDate: Max(Received_date_field)
vMonthEnd: MonthEnd(Received_date_field)
Hi,
Why 2008 is your data start from 2008 or what?
Regards
ASHFAQ
yes
i wanna get the all data till selected date