How to Calculate Post Date Order Values?

[#1]

Hi QV Team,

I need help on my Expression, How to sum-up Post Dated Order Values?

I've attached my excel sheet. Pls give me the expression to achieve this.

[jyothish8807]

Hi Murali,

Can you explain a bit more? what do u mean by post dated over here.

other wise simply create a straight chart:

Dimension: Date

Expression: sum(Value)

Regards

KC

[#3]

Hi,

There are some “orders”. These are orders where the delivery date is after the current date. I just need a new Column in Table box which shows all Future Date(Post Date) Orders need to sum up.

If[orders Date] > Today() then I need to sum(if(if blah blah... Pls help me

[anbu1984]

Can you post expected output

[#5]

Only It has to sum up all the Order values which is greater than today's date.

[anbu1984]

In chart,

Dimension: First Delv Date

Expression:

If([First Delv Date] < Today(), Sum(TOTAL If([First Delv Date] >= Today(), [Open Order])))

If([First Delv Date] < Today(), Sum([Open Order]))

[#7]

Hi Murali ,

take a straight table or pivot table

take dimension as date field and

in expression write the following

sum(if(datefield>today(),value))

Try it out

[jyothish8807 · Accepted solution]

Hi Murali,

PFA

Regards

KC

[tyagishaila]

Is this your requirement?

Plz show your expected result so that it will clear to us to find the actual result.

[tyagishaila]