24 Replies Latest reply: Aug 2, 2015 2:31 AM by arjun rao RSS

    Dynamic Straight Table Calculations

      I have a straight table and what to SUM() what is selected within a list box. However, within the list box is only each divisions name, such as Finance, HR, etc. When I originally imported my data from each division I used qualify, thus for a given metric such as PLAN, the field is named Finance.PLAN or HR.PLAN. Thus within my straight table I want to sum PLAN and FORECAST individually. In order to do this I have written the following, however I keep getting an error message that states: Error: Error in expression: Nested aggregation not allowed. Is there anyway to script what I'm trying to do?

       

       

      =Sum(Concat(getfieldselections([Divisions])&' .Plan'))