13 Replies Latest reply on Jul 17, 2017 10:57 AM by anjani

    Importing field

    anjani

      There is a field called "A" of number option and field "B" which is total summary (sum) of field A. I want to import import value of field B in another table of another file. I normally inserted B field in another file, but its not giving me total sum of field A, rather its poping up each values of field A in different record. How can i get sum of field A in another file.

        • 1. Re: Importing field
          ljungholms

          You may need to write this in a script.

           

          Set Variable [ $B; Value: "Your A Summary Field"]

          go to layout ["Other Layout"]

          Insert Calculated Result [Select; "Your other field"; $B]

           

          Add a button and attach the script

          • 2. Re: Importing field
            philipHPG

            What method are you using to import the value into the separate file? If you are using a script, it would be helpful to see the script as that will help us advise you better.

             

            Note that summary fields are based on the current found set so if you are not getting the desired value of field "B" when you copy it into the the other file, it is likely because the found set in your original file is not showing all the records that should be included in the summary. Without additional information, it is difficult to advise more specifically.

             

            What ljungholms suggests is one possibility, however you still need to be aware of the found set and it is advisable to use the Set Field script step instead of the Insert Calculated Result script step.

            • 3. Re: Importing field
              anjani

              Currently i am not using any script. M trying to solve this via calculations. I created a list of all the values in field A. and i am planning to add them up and store the value if possible.  Is this possible to do?

              • 4. Re: Importing field
                ljungholms

                FYI, if you are using calculations you do not "store" the info, it calculates each change. If you want to store the info you need a field to store the data.

                • 5. Re: Importing field
                  philipHPG

                  Please explain more how your system is currently structured. If you have a calculation in place, please post the calculation so we can advise you on it. It would be helpful to know what relationships are in place between the table occurrences.

                   

                  It is possible to set up a calculation field or a number field with an Auto-Enter calculation that references another field. However if the referenced field is from another table occurrence (and in this case you've indicated it's even a separate file), the calculation will be unstored and the Auto-Enter calculation won't automatically update when the referenced field changes.

                  • 6. Re: Importing field
                    anjani

                    what i did is

                    Second file[field B] = unsorted, calc[first file::field A].

                    But when m using this field B, its not giving me totl value of A. rather its only popping up lists of values its sum of.

                    • 7. Re: Importing field
                      ljungholms

                      That calculation is not pulling in a summary, just the number.

                      So you have

                      File 1 - Field A = 100

                      File 1 - Field B =  Summary of A = 100

                      File 2 - Field B = Pull info from File 1 - Field A = 100

                       

                      Is this a related table?

                      • 8. Re: Importing field
                        anjani

                        Yes. I only created relation table in database. Capture1.PNG

                        • 9. Re: Importing field
                          philipHPG

                          One possibility is to change your calculation to

                          = Sum ( first file::field A )

                           

                          However, when you say "its popping up a list of of values" that makes me think there is something more complicated going on. Normally, if you reference a field in a related table occurrence it will default to showing the first value (unless you use a formula like Sum that operates across all related records). So normally I would expect second file::field B to show the value from the first record in first file.

                          1 of 1 people found this helpful
                          • 10. Re: Importing field
                            ljungholms

                            OK, still not sure what you are trying to do. But it seems that you want a summary from Billing to insert into Fall 16 Billing?

                            • 11. Re: Importing field
                              anjani

                              oHh, sorry, i mean i need to insert a summary of amount from Fall 16 Billing to Billing .

                              • 12. Re: Importing field
                                beverly

                                I'm not sure if this helps, but a sorted export from one table (A) can save just the summary values. (.csv or .mer) then the values imported into the new table (B) will no longer be summary type, but raw values. Include any values that need to be static whether this needs to relate back to "A" or not.

                                 

                                You may also be able to script the gathering of the values using;

                                GetSummary() or perhaps ExecuteSQL()

                                but let's not overly complicate.

                                 

                                1. you have values in "A" which get summarized (yes/no?)

                                2. you want ONLY the summaries in "B"?

                                3. is there a relationship between A & B in a way that

                                SUM(relatedTable::numberFld) can be used?

                                Beverly

                                • 13. Re: Importing field
                                  anjani

                                  Value in A is total (summary) of list of amounts. and I want to import only the total amount (summary) in B. I have linked the two tables. as i shown in my attachment.