March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
As I didn't get any traction with my previous question, I'm trying to build my percentage calculation inside the report builder directly.
This is my table:
In the "%" column, I would like to create a simple expression that divides the value under the first "Users" column by the value under the second "Users" column.
How do I reference those two cells in an expression?
If I copy the content of the cells I get this (which makes every value 100%):
If I assign a name to the cells in the Text Box properties as below and then I use those names in the expression, I get another error:
And the same happens if I assign a label.
How can I reference these two cells to build a calculation in the report builder? Or, how do I declare those values?
Thank you in advance for your suggestions.
Solved! Go to Solution.
What expression are you building for the textbox names?
It should be like :
=ReportItems!CountofUsers0.Value/ReportItems!CountofUsers1.Value
eg in this report :
In Variance column I have put below expression and that works fine :
=ReportItems!Sales.Value/ReportItems!Quota.Value
What expression are you building for the textbox names?
It should be like :
=ReportItems!CountofUsers0.Value/ReportItems!CountofUsers1.Value
eg in this report :
In Variance column I have put below expression and that works fine :
=ReportItems!Sales.Value/ReportItems!Quota.Value
Fixed!!
Thank you SO much!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |