I have a chart of accounts and I am using set analysis to get the balance for specific accounts. The account codes are strings of four numbers, for example 0031, 1122, 2201.
My expression is quite simple:
sum({$<AccountNumber={0031}>} Balance)
but this doesn't work, it shows a balance of 0.00.
However if I change it to:
sum({$<AccountNumber={'0031*'}>} Balance)
this gives the correct balance, and so does this:
sum({$<AccountNumber={'>=0031 <=0031'}>} Balance)
I don't understand why the first expression doesn't work. Any ideas? Thanks, Paul
