Expression help

Tue, 27 Nov 2012 11:47:06 GMT

Hi all,

I am looking for some help with an expression please.

I have a week fiels (Cal_Week) and a sales field (SalesValue)

I am trying to do a straight table showing sales this week then going back 10 weeks.

so i have :

Sales This Sales -1 Sales - 2 Sales - 3 etc

Weeks

1000 954 985 1200 etc

i have the following expression which gives me the previous weeks sales

=sum({$<Cal_Week={$(#=Only(Cal_Week)-1)}>}SalesValue)

=sum({$<Cal_Week={$(#=Only(Cal_Week)-2)}>}SalesValue) etc

this all works great, but what i also want to add into the above expressions is to always show data even if no weeks are selected.

So when the app is opened by the user, i want them to see the most up to date week in the Sales This Week column.

Example.

if we are currently reporting on week 40, then i would want week 40 to be in the Sales This Week column, then going 10 weeks back from that.

then if the user was to select week 35 instead, then the Sales This week would reflect the week selected and go 10 weeks back from that.

Does that make sense?

Re: Expression help

MayilVahanan — Tue, 27 Nov 2012 11:51:44 GMT

use max() function,instead of only() function..

hope it helps