Thanks for the post, it may help us get a better understanding of what you need if you give more details on the report you are trying to create and how your calculation is setup and where exactly it is going wrong.
Thank you for your post.
It sounds like your calculation is performing a Sum or Count of a repeating field. This would definitely give you different results when you separate the repeating fields, because the summary would only be calculating over one repeated value instead of several.
Prior to the export, put the Summary value into Number field via a script. That way, when you split the records, the new value will be in the Number field.
Run the script:
Replace Field Contents (NumberField; Summary calculation field)
Thanks for your reply,
I will try what you just said. And I will tell you what happened. Also, is it possible to create a script that would automatically import records and split the repeating fields and match matching names and show it in a specific layout in just one click of a button?
Yes, this is possible. In your script, have:
Go to Layout [<layout with second table fields> ]
Import Records [no dialog; <specify data source>; <specify import order> ]
Then, you can create a button and set the button to execute this script.
I am assuming you will be running this script a number of times, so before the "Import Records" step, you may want to insert:
Show All Records
Delete All Records [no dialog]
That way, you remove all records before importing.
Thanks for the reply,
Sorry, been away lately...
I will try your script...
I'll update you on the results...
Thank you so much!