Forum Discussion
ldupont
4 years agoNew Member
Paginated report Expression column sum() Grand Total
HI All I' am working on a Paginated report below , and I would like make a Grand Total ( yellow ) on the expression line could you please help me ? Table created in matrix winzard M...
v-henryk-mstf
Community Support
4 years agoHi ldupont ,
You can name the text boxes for the total lines containing the totals as required and then place the final formula in the desired text box. link
like below:
=Sum(Fields!LineTotal.Value, "Order")
' or
=Sum(CDbl(Fields!LineTotal.Value), "Order")
You can also refer to the following similar solution, I hope it will help you.
Re: Paginated report Expression column sum() Grand... - Microsoft Power BI Community
If the problem is still not resolved, please point it out. Looking forward to your feedback.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ldupont
4 years agoNew Member
Hi v-henryk-mstf
Many thanks for your answer , I tried to apply your process but it doesn't works , I think I'm using it wrong
1- A rename the line by [wfline] = percentage calculated by line
2- I tried to insert your expression above, and I think that's where I went wrong.
"Sum(Fields!wfLine.Value, "Order")"what to put in place of order?