topic Re: How to reference a specific cell in a table of the report builder to build an expression in Report Server

How to reference a specific cell in a table of the report builder to build an expression

Anonymous — Fri, 07 May 2021 03:57:10 GMT

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.

Re: How to reference a specific cell in a table of the report builder to build an expression

AbhiSSRS — Fri, 07 May 2021 07:31:50 GMT

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

Re: How to reference a specific cell in a table of the report builder to build an expression

Anonymous — Fri, 07 May 2021 12:33:27 GMT

Fixed!!

Thank you SO much!