Does anyone have any idea what could be causing this issue
The holighted Cell Value should be the "Sum" of the groups "Items" but its total seems to be the same as the Items under Material even though there is no data in that Group for the Price Field
I've also included the code I wrote to calculate the totals for the Price Line. It only appears to happen if the entire gruop has a zero total
If I remove the PartName grouping the issues gets solved.
Inside of ds_AggregateMeasure
if (e.MeasureDescriptor.Name == "Price") { decimal total = 0M; decimal count = 0M; foreach (object o in e.Items) { var item = o as FrBudget; if (item != null) total += item.Price; count += 1M; } e.Value = total; e.Handled = true; }
It appears to happen to ANY meassure which has a TOTAL of 0
Hello Jose,
We cannot determine what the problem is from the code snippet you posted here, as your logic seems to be valid. In order to help us investigate further, could you please provide us with a sample which reproduces the issue? Any other information you could give us would be valuable as well.
I can't attach in the forum (only images / media)
But I've uploaded to the link you provided
IF.zip is the XML with the data
PivotData_IF.zip is the project
Thanks!
Thank you Jose, I have the sample working and reproducing the issue. We will look into this and update you on information as we uncover it.
Thanks! I'd love to get at least a work around!
I have investigated your issue, and I have asked our engineering staff to examine this further. To ensure that it will receive attention, I have logged this behavior in our internal tracking system with a Development ID of 217418. The next step will be for a developer to review my investigation and confirm my findings or to offer a fix, or other resolution.
I will update you with any workaround that we can find while we investigate the root cause of the issue.
Please let me know if you need more information.
Hi John,
Any update on this? Don't mean to be pushy, but this project is really high priority for me and I can't deploy until this is fixed.
Hi Jose,
Thank you for your feedback.
I am glad to hear that you have resolved your issue. Please let us know if you have any additional questions.
This did fix the issue, thank you!
Got the email thank you!
Jose,
I have addressed an issue internally, and you should now be able to find the email sent with your private build. Please let me know if this resolves your issue.
I have not gotten the email