Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
indiana256
Contributor
Contributor

Null Issue

 Hello! 😀


can somebody please explain to me, how to solve this trouble please

i have a matrix with 2 dimension from the same table, but i´m having issues when the expression calculated value is 0; it is grouped in a 0 Category and do not appear on the corresponding "Madre" dimension. I need the 0 values to be displayed in the corresponding "Madre" dimension.

 

 

Captura.PNGCaptura1.PNG

Here are the tables

Captura3.PNG

And the "Cuentas" table. The two selected are the dimensions in the matrix

 

Captura4.PNG

The expression is :

Captura5.PNG

 

where "MesActual" and "AñoActual" are variables that select the correct month and year.

 

Can somebody help me with this? 

 

Thanks in advance

Labels (4)
1 Reply
Ksrinivasan
Specialist
Specialist

Hi,

 

1. what you want to display?

2. you want show as Pivot Table or Chart?

3. Explain your Expression.

 

K. Srinivasan.