How divide records in Subject area

LuisRodriguez92 · 2025-02-12T15:59:22+00:00

There was an error rendering this rich post.

I am trying to perform either (* or / ) between two records however the output is always 0. However whenever I tried to + or - operations, it works.

Lets say:
Column 1: Value 20
Column 2: Value 10

I tried this → SavedExpression('Column1')/SavedExpression('Column2') and the output is always 0.

What am i doing wrong?

Find more posts tagged with

Accepted answers

All comments

Diane McElhiney

It would be helpful to post the expression syntax you are using in Column1 and Column2.

LuisRodriguez92

Oh sure. Didn't know it would be needed/helpful.

Column1: IIF([Stock Transaction Details.TTYP]=10,[TRDT: Sum: Transaction Net Weight_Stock Transaction],0)

Column2; IIF([Stock Transaction Details.TTYP]=11,ABS([TRDT: Sum: Transaction Net Weight_Stock Transaction]),0)

Diane McElhiney

Have you created a Table Visualizer report showing the TTYP attribute and the 2 measures (not the expressions) and filtering on TTYP using Visualizer filter confirming there is data? Another confirmation is to use the Table Visualizer to display the SavedExpression as columns. Is the data returned as expected?

These steps help narrow down the possible challenges. Another thing, is Transaction Net Weight_Stock Transaction only in one measure table. If this same-named column is in multiple measure tables with the Stock Transaction Details hierarchy related, then the Birst Query engine chooses which measure table is more performant in returning data.