Calculated variables from other tables not available in conditional logic

SMART Community Forum
1

Hi there,

I’m struggling to automate my report and would really appreciate some help.

First, I created a table and calculated a variable called calidadHidro using a dataset named CERAS.

image
image1227×785 45.6 KB

Then, I created a second table where I calculated another variable called calidadBio, also using the same dataset (CERAS).

image
image1231×721 44.9 KB

Finally, in a third table, I want to use calidadHidro and calidadBio to create a new calculated field with the expression builder (as previous steps).

The issue is that when I try to write the conditional code in the third table, the variables calidadHidro and calidadBio do not appear as available fields, so I can’t reference them in the code editor.

image
image1352×846 98.6 KB

Both variables are correctly linked to their source tables, and the third table is linked to the same dataset.

image
image1212×737 88 KB

image
image1225×732 86.9 KB

image
image1222×641 86 KB

Am I missing something? Is there a way to define a variable once and reuse it across different tables in the report? Or how can I calculate a new variable based on calculated fields from other tables?

Thanks for your ideas
Jackie

2

Hi Jackie,

You’re not missing anything fundamental — you’re running into a scope limitation that’s common in many reporting tools (SSRS / Report Builder / BIRT / Jasper / Looker Studio–style tools all behave similarly).

Why this is happening

  • calidadHidro and calidadBio are table-scoped calculated fields
  • They only exist inside the table where they were defined
  • Even though all tables use the same dataset (CERAS), calculated fields are not shared across tables
  • That’s why they don’t appear in the expression builder of the third table

In short:

Calculated fields are not global variables.

3

Thank you for your kind explanation. At the end, I left that part to be set manually.

Best regards,
Jackie