Line Item Subsets and COLLECT() function with calculated % Values
I have a reporting requirement which I cannot seem to perform due to limitations on Line Item Subsets and the COLLECT() function.
I have a Line Item from Source Module A which calculates the % value of one line vs another Line Item (% calc, summary is set to formula) in the same Module. I've created a Reporting Module B which contains a Line Item Subset which includes the '% calc' Line Item Subset Item in order to do some variance analysis.
When I COLLECT() the data from the Source Module A the '% calc' Line Item Subset Item in the Reporting Module B brings in an aggregated figure and not the calculated %.
Is there away to perform this reporting functionality using the Subset Line Item within the Reporting Module B without having to create a separate Module to handle the calculated % for the '% calc' Line Item as my Customer wants to export the Reporting Module B and to have to export two Modules each time would not be feasible.
Thanks in advance for any help.