Date()

[bhavvibudagam]

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.

[Nagaraju_KCS]

Try

=Sum({<OrderDate={"<=$(=Date(Today(),'DD/MM/YYYY'))"}, Status={'Completed'}>}OrderSalesAmount)

[jyothish8807]

Hi,

Try like this:

Count({<Duedate={"<=$(=date(today(),'DD/MM/YYYY')"},Status={'Completed'}>}issuenum )

[bhavvibudagam]

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.

[bhavvibudagam]

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.

[Nagaraju_KCS · Accepted solution]

=Sum({<OrderDate={"<=$(=Max(OrderDate))"}, Status={'Completed'}>}OrderSalesAmount)

[shiveshsingh]

Count({<Duedate={"<=$(=date(Max(Date),'DD/MM/YYYY')"},Status={'Completed'}>}issuenum )

[jyothish8807]

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