RunningValue inside a tablix

[Walter Martin]

I'm trying to get a complex result for a report in RDLC format and a Blazor application

I add in attachment the result expected, my result and the RDLC file

In the file "result-expected" I described in red the two values I don't know how to calculate and named them 3 and 4 in the picture

I tried to calculate number 4 using the function RunningValue because it seems to be the most closer to the result I need (detail / sum in the group)*100 but some of the values are correct (I highlighted them in green in the file my-result) and some other not (in red in the picture) and I can't understand why. It seems to be a problem of the order of calculation done but not only

Number 4 in the picture instead I don't have any idea on how to get the result because I should use the RunningValue in the sum of grouped row divided by the RunningValue in the sum of the total datasource rows but this gives me an error

The data are grouped by "posizione"

Do you have any solution or suggestion ?

Thanks

Attachment: Test_dcf307bf.zip

[Mahendran Shanmugam]

Hi Walter, 

We were not able to reproduce the mentioned issue. Could you please share the dummy data for this report and we will check the report with dummy data and we will update you the report to calculating the values. 

Regards, 

Mahendran S. 

[Walter Martin]

I add you the sample data file and the new RDLC where I removed the parameter not necessary

let me know if you need more information or something is not clear

thanks

Attachment: Test_2_e02821a4.zip

[Mahendran Shanmugam]

Hi Walter,  

Thanks for sharing the details in your shared report you have used the same field for getting the values from expression(“=Fields!orelav.Value/(RunningValue(Fields!orelav.Value,Sum,"posizione2"))*100”). For your case please use the expression like below to get the values from dividend of two field. 

= (Field1.value/Field2.values)*100 

If you want to get the sum of field 2 value based on group then could you please use the below expression. 

=(Fields1.Value/Sum(Fields2.Value,"posizione2"))*100 

Regards,  

Mahendran S. 

[Walter Martin]

Thank you very much Mahendran

You solved my problem

I think I don't understand the meaning of the function "RunningValue" because using your suggestion it works

[Mahendran Shanmugam]

Hi Walter,   

Thanks for your update. 

We are happy our suggestion was worked at your end. 

Regards,  

Mahendran S