You’re offline. This is a read only version of the page.
The scenario is as follows:
We want MR to read amounts from an Excel spreadsheet and use those amounts in a calculation. We have 2 departments and want them to allocate according to the Excel amounts. The spreadsheet has 2 tabs; Studio and Consumer. You can see below that it is taking the 80% (from Excel) and applying it against the total of 48,748 to get the proper amount.
Everything is calculating properly but for some reason our amount double when linking to the tree.
Because we need to mark 'use row definition from reporting tree', we copied the definitions to the tree.
When we drill down on an account we see the following:
It looks like the doubling is because of the Studio and Consumer lines but those refer to the 2 Excel tabs.
I have not been able to put those on one line to see if that would solve it...
Any ideas would be greatly appreciated,
Thomas
*This post is locked for comments
I have the same question (0)
Were you able to resolve the issue? I'm having the same problem and I've tried just about everything.
Thanks!
Bob
Share
Report
All responses (
Answers (
