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

    How do I accomplish Field data content Expansion

    Femi Adeniyi

      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:

       

      Table

      DescriptionFormula
      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.

      Femi