Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
)
the level for NonMat Deposits is 2
but you use 4:
sum({<LevelName={'NonMat Deposits'},
period = {'1'},
level = {'4'}>}PerInt)
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)
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.
got it. actually you're suggestion made me realize I had wrong cases. QV is case sensitive... duh!!! Thanks!
the level for NonMat Deposits is 2
but you use 4:
sum({<LevelName={'NonMat Deposits'},
period = {'1'},
level = {'4'}>}PerInt)
yes you are correct. I've fixed that as well as the casing, so all is well. Thanks again.