Warning Error Message :
RQP-DEF-0579 Warning: The footer aggregate operation 'aggregate' for the data item '' cannot be expressed in terms of the underlying subquery The result set may contain duplicate rows.
I have a Currency conversion filed which got calculation in Framework Manager, when I use that field in Report with grouping it is not giving the total value for specific groupings but gives the sum value for the total report. I guess, it is an issue with aggregation. Could someone help me out how to fix this please. The above mentioned error message pops up when i validate the report.
Please let me know if any further information required. Thanks