Set analysis for today is not working

[priyalvp24]

Hi All,

My date field is DocDate.

I want to calculate the total Deliveries for today.

My set expression is

Sum({<DocDate={'=$(=Date(Today()))'}>}Delivered_Quantity)

example: Total Delivered Quantity 7000

Delivered Quantity for today 500

It giving me the result as Total Delivered Quantity till today i.e. 7000 but i want result for today i.e. 500 

Please help.

Regards,

Priyal

[thannila]

can you please attach the sample data?

[Ivan_Bozov]

Make sure that the DocDate format is the same as the one defined in your Main script section, e.g. DD.MM.YYYY. 

You can use the Date function in the set analysis to adjust this, e.g.

Date(Today(), 'DD.MM.YYYY')

Also use double quotes in the set analysis as this is a search string. 

[priyalvp24]

PFA.

[Chaurasiamit]

Sum({<DocDate={"$(=Num(Date(Today())))"}>}QTY)

use this set analysis and make sure your  date is in NUM format.

QTY =Delivered_quantity 

[priyalvp24]

sorry but not working

[shiveshsingh · Accepted solution]

Hi

Try this.

Script:

T:
LOAD Date,
Date(floor(Date),'DD/MM/YYYY') as Date_N,
Delivered_Quantity,
Status
FROM
[C:\Users\XYZ\Desktop\Dummy Data.xlsx]
(ooxml, embedded labels, table is Sheet1);

Your expression in text box :

=sum({<Date_N = {"$(=Date(Today(),'DD/MM/YYYY'))"}>}Delivered_Quantity)

[priyalvp24]

Thanks,its working....

[shiveshsingh]

Glad to know it helped