7 Replies Latest reply: Dec 7, 2012 2:20 AM by whiteline _ RSS

    How do I accomplish Field data content Expansion

      Hi All,


      I ll like to be able to do set analysis expresions based on the content of a field in a specific table. Pls see the example below:



      Sales Turnover10101, 10102, 10107
      Admin Expenses51010, 51023


      The above table shows a template for calculating sales & admin expenses. Its simply by summing all amount in the transaction file (not shown) where AccountNo is equal to each of the accounts specified in the formular above.


      How do I write an expression to accomplish this?


      This is the code I could come up with, but its not working.


      = Sum({$<GLActNo={$(formular)}>} Amount)



      Thanks in advance.