SUMPRODUCT in Paginated Report using MS Report Builder

Hi,Anonymous .I am glad to help you.
In Power BI Desktop, you can easily calculate results with DAX, while in Power BI Report Builder, creating a custom method would be a good option.
Maybe you could try :

Public Function CalculateSumProduct(ByVal startFTP As Double(), ByVal previousBalance As Double()) As Double
    Dim sumProduct As Double = 0
    For i As Integer = 0 To startFTP.Length - 1
        sumProduct += startFTP(i) * previousBalance(i)
    Next
    Return sumProduct
End Function


=Code.CalculateSumProduct(Fields!StartFTP.Value, Fields!PreviousBalance.Value) / Sum(Fields!PreviousBalance.Value)

Custom code in expressions in a paginated report in Power BI Report Builder - Power BI | Microsoft Learn

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Anonymous,

 

Thank you for reaching out to the Microsoft Fabric Forum Community.

 

Try using this expression to get the SUMPRODUCT.

Expression = Sum(Fields!StartFTP.Value * Fields!PreviousBalance.Value) / Sum(Fields!PreviousBalance.Value)

If you found this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to help others in the community.

 

Thank you & regards,
Prasanna Kumar

Hi Anonymous,

 

Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful — this will benefit others in the community as well.

 

Best regards,

Prasanna Kumar

Hi Anonymous,

 

We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.

If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution — it helps others who might face a similar issue.

 

Warm regards,

Prasanna Kumar

Hi Anonymous,

 

Just a gentle reminder — has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Thank you for your time and feedback!

 

Best,

Prasanna Kumar