function with max (date) doesn't work in set analysis

[chriscools]

Hello,

i have an expression to give me the sum of € open for a certain date:

sum({<OrderDateDeliveryFrom ={"<15/2/2013"}>} OrderPriceUnitNet  * OrderQtyOpen ) 

And this works ok, but i don't want to change the date everytime i want a current number, i tried this:

sum ({<OrderDateDeliveryFrom = Max (Date) >} OrderPriceUnitNet  * OrderQtyOpen ) 

but it doesn't work...

can someone see what i did wrong?

thanx!!

chris

[Gysbert_Wassenaar · Accepted solution]

Try:

sum ({<OrderDateDeliveryFrom = {'$(=Max(Date))'} >} OrderPriceUnitNet  * OrderQtyOpen )

[leonardo_raed]

Hi Chris,

I always use a straight table to see how the set analysis is evaluated. You can do it keeping the label of the expression empty.

For example:

[chriscools]

Hey Leonardo,

i don't understand how you build your evalution and how i should read it to conclude what might be wrong.

actually i'm not at all familiar with what your doing... 🙂

grtz,

chris

[chriscools]

Hello Gysbert,

i tried to do the same to give me the sum for the current week by doing this, but why doesn't that work if i add the week?

sum({<OrderDateDeliveryFrom = {'$ (= Week( Max (Date)))'} >} OrderPriceUnitNet  * OrderQtyOpen ) 

grtz,

chris

[Gysbert_Wassenaar]

Week returns the week number as an integer, not a date. You'll have to use something like

OrderDateDeliveryFrom = {'>=$(=weekstart(max(Date)))<=$(=max(Date))'}

[#7]

Me ayudas por favor?

Indicador en Tabla pivote