Wednesday, May 02, 2012 6:03 PM
I have a requirement where i need to develop a report for crm 2011 online
I have 2 attributes "This Year" and "Last Year"
I have to show the Top 50 values of the difference value i,e This Year - Last Year Value
How can i do this? Any Work Round for this
Thursday, May 03, 2012 6:30 AMModerator
I'm not sure if you can do this with reporting in Crm Online. FetchXml will not support doing the calculation ('This Year' - 'Last Year'); you might be able to use a field that is calculated within the report, however Crm Online restricts the functions that can be used in reports, so this may or may not work.
If a calculated field in the report doesn't work, then I think you'll need a different approach. A couple of options are:
- Write a plugin that calculates ['This Year' - 'Last Year'] and places the result in a new field. You could then report on this field
- Have the users export the data to Excel, and do the calculation and filtering within Excel
- Edited by DavidJennawayMVP, Moderator Thursday, May 03, 2012 6:30 AM