2 Replies Latest reply on Mar 18, 2014 4:01 AM by sccardais

    Use Found Count in Calculation

    sccardais

      Title

      Use Found Count in Calculation

      Post

           I would like to display a % calculated value in a subsummary report based a summary field in the layout and the found count of a related table.

           The sub summary report is "Ranking of Issues" It is based on the table Join_Issues_Mentioned.

           The numerator is a summary field "Summary_Count_Issues" which counts "Issues Mentioned" in the Join_Issues_Mentioned table.

           For each row in the sub summary report, I want to divide the count by the Found Count of records in a related table, "Surveys."

           Count of Issues Mentioned by the found count of records in a related table - Surveys

           This is a rough summary of the steps I think are needed.

             
      1.           Go to Surveys layout that includes a portal showing Issues Mentioned from the Join_Issues_Mentioned table
      2.      
      3.           Enter Find Mode
      4.      
      5.           Go the field "Issues Mentioned" in the first portal row.
      6.      
      7.           Enter an asterisk to find only those surveys that have at least one issue assigned.
      8.      
      9.           Perform Find
      10.      
      11.           Get the found count
      12.      
      13.           Store the found count
      14.      
      15.           Go to Layout "Ranking of Issues" which is based on the Join_Issues_Mentioned
      16.      
      17.           Use the Found Count to calculate and display the % each issue represents of the Surveys that have at least one Issue assigned.
             
      •           Note: The Count is a summary field in Join_issues_Mentioned = Count of Issues Mentioned.

           So far, I have not been able to make this work. 

           Hopefully, the attached screenshot will clarify this. Is it possible to do what I'm trying to do? Should I be using a global field or a variable? The screenshot shows part of the layout and the % shown is forced just to illustrate what I'm looking for.

            

      Calculating_Percent_based_on_related_table.png

        • 1. Re: Use Found Count in Calculation
          philmodjunk

               You cannot access the "found count" of anything but the table occurrence specified in layout setup for the current table. If you want a count of the number of records in a related table that match to the current record in the current table, the count function can return that value.

               Your only other option would be to use a script to find the records in the other table, set a variable to the found count and then your calculations would refer to that variable or a field set by your script from that variable.

          • 2. Re: Use Found Count in Calculation
            sccardais

                 Thanks.

                 Your 2nd suggestion (create script to set variable to found count) worked.