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.
Also if I remove the additional TotalCost measure the value then works ok, but adding any additional measures breaks it
Jose,
I cannot download from the link you sent me because our security software blocks downloads from that site. You should be able to attach the .zip file right into this forum thread.
If the file is too large to be able to attach here, try deleting the bin directory, which takes up a lot of space and is unecessary for me to build and run the sample. If it is still too large, you can upload the file here: https://filetransfer.infragistics.com/public.php?service=files&t=559ccfe7089dff00971d73a9758b4626
Please let me know if you are able to follow any of these avenues to send your sample.
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!
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.
Hi John,
This did fix the issue, thank you!
Got the email thank you!
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