Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i need a requirement for my expression :
For Example,
Outlook Month | October Value | November Value | Dec Value |
---|---|---|---|
9 | 2 | 3 | 4 |
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
Try to share a sample app.
hi,
do you want the data from jan to dec without selecting month. please explain.
try this- sum(outlook month)
Regards,
Himanshi
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.
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.
can i use your expression?
Thanks and Regards,
Dida
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.
can i use your expression?
Thanks and Regards,
Dida
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?
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
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.
Hi,
Problem solved, thx