Hi,
Have this table with this values
date -> qty
01.01.2010 -> 6453
02.01.2010 -> 4818
When I use:
= {Net. Sale per sqm} Where (ToDate([L01 Calendar day Key];"dd.mm.yyyy")>=ToDate("01.01.2010";"dd.mm.yyyy") And ToDate([L01 Calendar day Key];"dd.mm.yyyy")<=ToDate("01.01.2010";"dd.mm.yyyy") )
Result = 6453
But when I use:
= {Net. Sale per sqm} Where (ToDate([L01 Calendar day Key];"dd.mm.yyyy")>=ToDate("01.01.2010";"dd.mm.yyyy") And ToDate([L01 Calendar day Key];"dd.mm.yyyy")<=ToDate("02.01.2010";"dd.mm.yyyy") )
Result = #TOREFRESH
Can RunningSum help me here or should I use other?
Note: Used { instead of [ 'cause message otherwise will change sentence to a URL
Thank you