Application of a formula on vales of different codes are not appeared against each code

[nevilledhamsiri]

Hi, Community

Please look in to my calculation which was done on separate codes by application of a formula in the P/T. The formula used to multiply is  there in the straight table. The issue is once applied, correct amount is shown on the total row but I need the same amounts to be shown against the each code.

Please help

Neville

[nevilledhamsiri]

One such as below used. But an error message with ''Error in cal dim'" appear. Check why. Attached the data

=ONLY({<ACCOUNT_CODE={'77150','78310','77151','78330'}>}ACCOUNT_CODE)

[dplr-rn]

That's the log file

[nevilledhamsiri]

Sorry once again, once it is applied as an expression, output comes.

Thanks a lot.

Also I wish to know the fact that most of the formula though I use cannot be kept in my memory. mostly I make some errors while writing them may be at times a quotation mark, code etc resulting an error. what best method you may propose me in becoming better such as making perfect in this area. Any fitting practices etc you follows because I am just a professional Accountant does not have much IT back ground as such but I am very ken on learning IT

[dplr-rn]

Not sure. for syntax i tend to follow some basics like if you open a bracket you close it immediately and put code inside the brackets. may seem a pain at first but pays off in long run

Alternatively you can use

some tools like https://www.qlikviewaddict.com/p/qlikview-notepad.html