Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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'))
Your application attached with the correct expression for the Categories 661 list box also
may be try this..
Middle may be 661 and not 668. May be I could be wrong..
Seems like the number keeps on getting changed everytime
Got it, it seems to be driven by an expression I get 661 still. Is 661 for Middle incorrect?
661 should be correct as per my view. Have you consider Customer as well in listbox aggr?
I did not, but I think I should because that is one of the dimensions on the chart, right?
I guess if Internal ID is unique, we might not need customer.
Thanks for all your help guys, remarkable teamwork!!!!!