Sum - Select - Year less then

[#1]

Hello.

I Have a table:

Year	Value
2001	1
2002	2
2003	3
2004	4
2005	5
2006	6
2007	7
2008	8
2009	9
2010	10

I must create a bar chart, include only 5 years: 2001, 2002, ..., 2006.

I use a sum with select: sum({<Year={XXX}>}Value)

What i must insert instead XXX?

<=2006 not work

Thank you.

[alexandros17]

If year is even a dimension then write in dimension

If(Year<=2006, year, null())

and check the box "Hide null values"

let me know

[#3]

Thank you, but i have a another formula in my app and "IF" don't work.

Original formula:

sum({<measureName={Opex, Expenditure}, budgetName={"Approved"}, Year={less then needed year}>}quantity)

[alexandros17 · Accepted solution]

Now it's clear:

write this:

sum({<measureName={Opex, Expenditure}, budgetName={"Approved"}, Year={'<=2006'}>}quantity)

let me know

[maternmi]

Hi,

maybe that helps

sum({<Year={'2001','2002','2003','2004','2005','2006'}>}Value)

BR

Michael

[#6]

No

"Error in set modifier ad hoc element list"

[Anonymous]

Hi

Use single quotes '<=2006'

=sum({<Year={'<=2006'}>}Value)

It will work.

[Anonymous]

Hi,

Try:

Sum({$<Year = {"<=$(=max(Year))"}>} Value)

[#9]

Sorry. It's work.

Thank you.

[alexandros17]

Could you mark the answer please?