Set analysis problem

[#1]

Hi, I'm having trouble with my set analysis.  Basically, I use the following set analysis and it disregards the 'level' criteria.  Thanks, Jim

)

sum({<LevelName={'NonMat Deposits'},

     period = {'1'},

          level = {'4'}>}PerInt)

+

sum({$LevelName={'Non-Wholesale','Time Deposit Adjustments'},

     period = {'1'},

          level = {'4'}>}PerInt)

)

[bgerchikov]

Hi,

Not quite sure whether you use correct syntax. You have "$" instead of "<" in second Sum. Also, I'd suggest try this instead:

sum({<LevelName={'NonMat Deposits','Non-Wholesale','Time Deposit Adjustments'},

     period = {'1'},

          level = {'4'}>}PerInt)

[#3]

sorry I miss typed it, I have the $ and < in both places.  The reason I add the 2 is that the level for NonMat Deposits is 2 and the level for Non-Wholesale and Time Deposits is 3 and 4.

[#4]

got it.  actually you're suggestion made me realize I had wrong cases.  QV is case sensitive... duh!!!  Thanks!

[whiteline · Accepted solution]

the level for NonMat Deposits is 2

but you use 4:

sum({<LevelName={'NonMat Deposits'},

      period = {'1'},

           level = {'4'}>}PerInt)

[#6]

yes you are correct.  I've fixed that as well as the casing, so all is well.  Thanks again.