How do I get a summation Converted onto one currency in a report?
Answers
-
The sum function in a report will just sum up all values, irrespective of the currency. The only way to get you the list with sums of similar currencies will be to filter it in the report. You will have two reports, one filtered for USD records and the other for CAD records. Another option is to have a separate column to convert all the values to one currency and then sum on that column instead of the standard column you use.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives