Hello everyone, I'm pretty new here and do have a question about the "caculated item" in VA reporting build. I hope, that someone can help me here. Thanks a lot. The following "calculate item" was build in the VA report: Sum [_ByGroup_] (( 'quantity'n * 'unit_price'n )) / Distinct [_ByGroup_] ( 'oder: ID'n) What I need is to build the summary of price and then divided by the number of orders, so I can get the average value of price pro order. In my data source table I have position of the order per row. So in the source I may have several rows with the same order ID but different position number. That's why I used "Distinct". But the summary of price is based on all the rows. So after I build the item it appeared under "Aggregated Measure" in the left side of the VA. But when I try to drop this item in my report. I got the "Error Message" How can I get the average value and use it in my report?? Kind regards, Oliver
... View more