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.
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
Dimension: First Delv Date
If([First Delv Date] < Today(), Sum(TOTAL If([First Delv Date] >= Today(), [Open Order])))
If([First Delv Date] < Today(), Sum([Open Order]))