Nested IF statement List Box

[#1]

Hi All,

I have situation where I've a if statement which isn't filtering out the right way. It shows Small when it should be showing Middle and Middle when it should be showing Large.

<= 500 Small

<=12000 Middle

else Large

Please provide insights!!!!!!!!!

Thanks,

[sunny_talwar]

Try this may be:

=If(RangeAvg(Sum(SepRound),Sum(OctRound),Sum(NovRound),Sum(DecRound),Sum(JanRound),Sum(FebRound)) <= 500, 'Small',

If(RangeAvg(Sum(SepRound),Sum(OctRound),Sum(NovRound),Sum(DecRound),Sum(JanRound),Sum(FebRound)) <= 12000, 'Middle', 'Large'))

[sunny_talwar]

Your application attached with the correct expression for the Categories 661 list box also

[MK_QSL · Accepted solution]

may be try this..

[MK_QSL]

Middle may be 661 and not 668. May be I could be wrong..

[sunny_talwar]

Seems like the number keeps on getting changed everytime

[sunny_talwar]

Got it, it seems to be driven by an expression I get 661 still. Is 661 for Middle incorrect?

[MK_QSL]

661 should be correct as per my view. Have you consider Customer as well in listbox aggr?

[sunny_talwar]

I did not, but I think I should because that is one of the dimensions on the chart, right?

[sunny_talwar]

I guess if Internal ID is unique, we might not need customer.

[#11]

Thanks for all your help guys, remarkable teamwork!!!!!