13 Replies Latest reply: Feb 25, 2016 5:45 AM by Sunny Talwar

# Want to show a value and all the values under that value

Hey guys. would appreciate some assistance over here. Expression wise.

My expression currently looks like this:
Sum({<[Kontonummer]>} [Bokfört belopp]) * Sum([Andel av kapital]) - '919650'

And I don't want to show anything ABOVE the value '919650'. when using this expression. Only '919650' and all the values under that value.

Kind Regards

D.Z

• ###### Re: Want to show a value and all the values under that value

May be this:

If(Sum({<[Kontonummer]>} [Bokfört belopp]) * Sum([Andel av kapital]) < 919650, Sum({<[Kontonummer]>} [Bokfört belopp]) * Sum([Andel av kapital]))

• ###### Re: Want to show a value and all the values under that value

Or like this:

RangeMin(

Sum({<[Kontonummer]>} [Bokfört belopp]) * Sum([Andel av kapital]) - '919650'

, 919650

)

• ###### Re: Want to show a value and all the values under that value

The choice depends on what do you want to do with the higher values - ignore them, or limit them by 919650 ?

• ###### Re: Want to show a value and all the values under that value

I want to limit them by 919650

• ###### Re: Want to show a value and all the values under that value

Hey guys. I tried both expressions but I am not getting what I am looking for.

All values under 919650 has to be shown and in that case Sunny T's expression is correct but every value that is above 919650 should just type out 919650 and nothing else above.

In your expression Oleg, all values are 919650 and nothing below or above that value

• ###### Re: Want to show a value and all the values under that value

Try this:

If(Sum({<[Kontonummer]>} [Bokfört belopp]) * Sum([Andel av kapital]) < 919650,

Sum({<[Kontonummer]>} [Bokfört belopp]) * Sum([Andel av kapital]), 919650)

• ###### Re: Want to show a value and all the values under that value

King! Thanks Mate

• ###### Re: Want to show a value and all the values under that value

If i want a total sum at the top of all this. Is it possible?

• ###### Re: Want to show a value and all the values under that value

Do you want a sum which satisfy your condition? or do you want to sum actual numbers?

• ###### Re: Want to show a value and all the values under that value

I want a sum of my current expression/condition at the top.

• ###### Re: Want to show a value and all the values under that value

Try this:

Sum(Aggr(

If(Sum({<[Kontonummer]>} [Bokfört belopp]) * Sum([Andel av kapital]) < 919650,

Sum({<[Kontonummer]>} [Bokfört belopp]) * Sum([Andel av kapital]), 919650), YourChartDimensions))

• ###### Re: Want to show a value and all the values under that value

Thats spot on my friend. Thank you so much for the help and have a nice day

• ###### Re: Want to show a value and all the values under that value

No problem at all