10 Replies Latest reply: Dec 28, 2015 4:23 AM by Sangram Reddy

# expression without tick my dimension

Hi,

i need a requirement for my expression :

For Example,

Outlook MonthOctober ValueNovember ValueDec Value
9234

with outlook month = 9 , i have to sum value from october - december which is 2+3+4 = 9

and my revenue from jan - sept = 10

so the result of outlook -FY = 19

question : how to use expression without tick my dimension month?

Thanks and Regards,

DSK

• ###### Re: expression without tick my dimension

Try to share a sample app.

• ###### Re: expression without tick my dimension

hi,

do you want the data from jan to dec without selecting month. please explain.

try this- sum(outlook month)

Regards,

Himanshi

• ###### Re: expression without tick my dimension

Hi,

i have to sum my revenue from jan - sept

and i have to sum my outlook value from oct, nov, and dec with my outlook month = 9

so the result is, my outlook value at month 9 = 9 + my revenue from jan - sept = 10 = 19.

all the condition without selecting month.

Thanks and Regards,

Dida

• ###### Re: expression without tick my dimension

Hi Dida,

If you want to sum up the values of October, November and December to make the value of 9 for October, use the below expression

rangesum(below(sum(values),1,11))

And for Jan to Sept use:

rangesum(above(sum(values),1,11))

The sum of both will give you a figure of 19 if used together.

• ###### Re: expression without tick my dimension

Hi Sangram Reddy,

i have to sum my revenue from jan - sept

and i have to sum my outlook value from oct, nov, and dec with my outlook month = 9

so the result is, my outlook value at month 9 = 9 + my revenue from jan - sept = 10 = 19.

all the condition without selecting month.

Thanks and Regards,

Dida

• ###### Re: expression without tick my dimension

Hi Dida,

I think you can. Use : rangesum(below(sum(values),1,11)) to sum all the months below a particular month (Not inducing the month being refereed to) ex: If its Sept, it will sum up Oct, Nov and December and its the viceversa with the other expression. Can you post an example so that I can do it for You?

• ###### Re: expression without tick my dimension

Hi Sangram,

here my expression for revenue :

sum({<Level2 = {'REVENUE'}, Level3 -= {'TOLLING FEE'}>}ValueLocalCurrency/-1)

with selecting month :

and the expression for outlook :

=

(sum({<TypeForecast={'Outlook'},FieldDescription={'xxx Spot Sales',yyy Sales','zz Sales'},MonthofOutlook={'9'},Month={'10','11','12'}>}ValueForecast/1000))

with selecting month

can i use your expression to get the value without selecting month?

Thanks and Regards,

Dida

• ###### Re: expression without tick my dimension

Hi Dida,

I think you can. Is it possible to post a sample QVF so that I will be able to help you better.

Thanks,

Sangram Reddy.

• ###### Re: expression without tick my dimension

Hi,

Problem solved, thx

• ###### Re: expression without tick my dimension

Welcome always!