Hello,
I have a simple table object with 11 dimensions and 3 expressions and each expression makes a calculation. Whenever all the of the expressions' calculation is equal to 0 (zero), the record is not shown on the table and that is the correct behavior.
Now, the problem I am having right now is that I need show the consecutive of each row but when I add one new expression with the RowNo(Total) expression it adds the records with the previous expressions' calculation equals to zero.
Example:
- This is what it is happening without the RowNo(Total) expression
| Dimension 1 | Dimension 2 | Dimension 3 | Expression 1 | Expression 2 | Expression 3 |
|---|
| Aliquam et nisl | vitae ipsum sceler | eget quis est | 1 | 0 | 3 |
| Ut arcu massa | dictum et feugiat | vulputate in pur | 0 | 0 | 2 |
| Suspendisse tellus | imperdiet et ultrice | porta sit amet | 7 | 2 | 0 |
- This is what is happening with the RowNo(Total) expression
| Consecutive | Dimension 1 | Dimension 2 | Dimension 3 | Expression 1 | Expression 2 | Expression 3 |
|---|
| 1 | Aliquam et nisl | vitae ipsum sceler | eget quis est | 1 | 0 | 3 |
| 2 | Duis rhoncus | ipsum nec | felis viverra | 0 | 0 | 0 |
| 3 | Ut arcu massa | dictum et feugiat | vulputate in pur | 0 | 0 | 2 |
| 4 | Suspendisse tellus | imperdiet et ultrice | porta sit amet | 7 | 2 | 0 |
| 5 | Sed eu arcu | et posuere risus | quam at lacus | 0 | 0 | 0 |
- What I need:
| Consecutive | Dimension 1 | Dimension 2 | Dimension 3 | Expression 1 | Expression 2 | Expression 3 |
|---|
| 1 | Aliquam et nisl | vitae ipsum sceler | eget quis est | 1 | 0 | 3 |
2 | Ut arcu massa | dictum et feugiat | vulputate in pur | 0 | 0 | 2 |
| 3 | Suspendisse tellus | imperdiet et ultrice | porta sit amet | 7 | 2 | 0 |
Thanks for taking the time to read this.
Ryuma,
