Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below requirement.
I have a Due date field in DD/MM/YYYY format.
I need to calculate the below measure
all items where duedate<= today and Status = completed in set analysis.
all items count(issuenum ) is there how to apply the above condition in set analysis.
Please help me on this.
Thanks in advance.
=Sum({<OrderDate={"<=$(=Max(OrderDate))"}, Status={'Completed'}>}OrderSalesAmount)
Try
=Sum({<OrderDate={"<=$(=Date(Today(),'DD/MM/YYYY'))"}, Status={'Completed'}>}OrderSalesAmount)
Hi,
Try like this:
Count({<Duedate={"<=$(=date(today(),'DD/MM/YYYY')"},Status={'Completed'}>}issuenum )
Hi Jyothish,
Thanks for your reply.
Could you please help me how to change the above expression for Max(Date) because In the source I haven't found today date.
Hi Raju,
Thanks for your reply.
Could you please help me how to change the above expression for Max(Date) because In the source I haven't found today date.
=Sum({<OrderDate={"<=$(=Max(OrderDate))"}, Status={'Completed'}>}OrderSalesAmount)
Count({<Duedate={"<=$(=date(Max(Date),'DD/MM/YYYY')"},Status={'Completed'}>}issuenum )
Count({<Duedate={"<=$(=date(Max(Date),'DD/MM/YYYY')"},Status={'Completed'}>}issuenum )
In the above case you have to be sure that you have two date fields 1. Duedate 2. Date
Count({<Duedate={"<=$(=date(Max(Duedate),'DD/MM/YYYY')"},Status={'Completed'}>}issuenum )
If i change the date to Duedate then it will not make any difference since all the duedate will be less that max(Duedate).
I believe there is something you are still missing wrt the requirement.
Br,
KC