When I run the Concur report for expense claim, the amount always shows the total of the same expense type for the same day rather than show numbers separately based on the comments, which shows incorrect numbers. May I ask which function can be used to divide costs?
Thanks in advance!
@vincentjiang there is an option in Query Studio that automatically combines expenses with the same expense type when building your report. You can turn this off by following these steps:
1. With your report open in Query Studio, click Manage File under the Menu on the left side of the screen.
2. From the Manage File options, click My Preferences. You will see some options appear below your report details.
3. Click Advanced Run-time Options.
4. Uncheck the Automatically summarize detail values, suppressing duplicates.
Give this a try and see if it gives you what you need.