Forum Discussion
SUMPRODUCT in Paginated Report using MS Report Builder
Using the Paginated Report in MS Report Builder, I'm trying to calculate a SUMPRODUCT for a column Total. The SUMPRODUCT that I need to calculate is: SUMPRODUCT(Start FTP, Previous Balance, Total P...
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