Skip to Content
0
Former Member
Feb 22, 2011 at 09:00 AM

RunningSum, Sum, ...

24 Views

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