Forum Discussion
Paginated Report - Calculated Field
I'm working with a paginated report, have a calculated field that displays encumbrances. I need to create a total for this column based on the following formula (Beginning Balance - YTD Expenses + YTD Receipts), when I do Sum(BegBal-YTDExpenses + YTD Receipts), it is only totaling YTD Expenses + YTD Receipts). Any insight would be appreciated. (All of these values are currently being displayed on the current report)
1 Reply
v-abhinavmuCommunity Support
Hi Bernice,
Thanks for reaching out to the Microsoft Fabric Community forum.You could try applying Sum to the complete calculation:
=Sum(Fields!BegBal.Value - Fields!YTDExpenses.Value + Fields!YTDReceipts.Value)Replace the field names with the actual dataset field names in your report.
According to the Sum function documentation, the function aggregates the result of the specified expression. If the total still doesn't match the expected value, check the scope in which the expression is evaluated. By default, Sum uses the current scope, which depends on the expression's location and, for a tablix cell, its row and column groups.
Could you clarify whether the calculated encumbrance is defined as a dataset field or as an expression in a report textbox? This would help determine the appropriate expression for your report.
For more details, please refer to the below Official Microsoft Documentation:
Expressions in Power BI Report Builder - Power BI | Microsoft Learn
I hope this helps. Please feel free to reach out if you have any further questions.
Thank you.