Adding the Value of Two Textboxes in Separate Tables

Question

Hello,&nbsp;This issue has been driving me crazy, so if someone is able to come up with a solution I will be extremely thankful.&nbsp;To give an overview of the issue, I am attempting to sum the values of two textboxes together, but that are in two different tables, and are using two different datasets. So simply doing&nbsp;ReportItems!Textbox10.Value + ReportItems!Textbox20.Value won't work.&nbsp;Now diving into what these textboxes are made up of, this is the expression for Textbox10:=SUM(IIF(DateAdd("m", 1, Parameters!Quarter.Value) = Fields!Exit_Date.Value,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Lookup(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Fields!Investment.Value,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Fields!Investment.Value,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Fields!Recallable_Amount.Value,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "SumInvestmentsMeasures"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ))&nbsp;Textbox 20:=SUM(IIF(DateAdd("m", 1, Parameters!Quarter.Value) = Fields!estimated_date.Value,Lookup(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Fields!deal_name.Value,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Fields!deal_name.Value,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Fields!Discretionary_Reserves.Value,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"InvestmentReserves"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ) / 1000000,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; ))&nbsp;If someone has an idea of how I can get the values of these two textboxs to be aggegated, it would be a saving grace.

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
Create Custom Code Functions: You can write custom functions to aggregate your values.
Modify Your Textbox Expressions: Use the function within your existing expressions for Textbox10 and Textbox20 to add their values to the total. For example, for Textbox10, modify the expression.
=Code.AddToTotal(SUM(IIF(DateAdd("m", 1, Parameters!Quarter.Value) = Fields!Exit_Date.Value, Lookup(Fields!Investment.Value, Fields!Investment.Value, Fields!Recallable_Amount.Value, "SumInvestmentsMeasures"), 0)))
&nbsp;
&nbsp;To display the aggregated value, you can create another textbox and set its expression to . This textbox will display the sum of the values from Textbox10 and Textbox20.=Code.GetTotal().
&nbsp;
&nbsp;
How to Get Your Question Answered Quickly - Microsoft Fabric Community
&nbsp;
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
&nbsp;
Best RegardsCommunity Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;
&nbsp;
&nbsp;
&nbsp;

Forum Discussion

Adding the Value of Two Textboxes in Separate Tables

1 Reply

Related content

Rotate a Textbox

Adding columns

Thousand-Separator-and-Decimal-Separator

Architecture decision : Separate workspaces

Dynamic TextBox