Calculate today, tomorrows and day after tomorrows

[#1]

HI all,

I have a scenario, where i need to find

Today quantity and tomorrows Quantity and Day after tomorrows quantity

Attached the application.

[PradeepReddy]

can you elaborate your requirement?

[settu_periasamy]

Hi,

Normally, it would be like this..

today :  =sum({<DateField={"$(=Date(Today()))"}>}Qty)

today +1 : =sum({<DateField={"$(=Date(Today()+1))"}>}Qty)

[#4]

business scenario

I have a item for that i got 100 quantity order to manufacture but today i produce only 30 items and postpone 50 items tomorrow and 20 items day after tomorrow.

ID|  Today     | Qty| (WIP(work in Progress)) | Backlogs | Tomorrow |Qty | Day after Tomorrow | QTY | Total QTY

x1|  21/12/15  |30  | 30                                 | 70           | 22/12/15   |50   |  23/12/15                | 20    | 100

[jagan · Accepted solution]

Hi Vamsi,

Try this expressions

Expression for Today = Sum({<MonthField=, YearField=, QuarterField=, DateField={"$(=Date(Today()))"}>}Qty)

Expression for Tomorrow= Sum({<MonthField=, YearField=, QuarterField=, DateField={"$(=Date(Today() + 1))"}>}Qty)

Expression for day after Tomorrow= Sum({<MonthField=, YearField=, QuarterField=, DateField={"$(=Date(Today() + 2))"}>}Qty)

Regards,

Jagan.