Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I need to show the rows no in the measures field. So, I used this expression on the condition of measure
GetSelectedCount(_measures) > 0
and the defination is this :
But it showing me the rows no even the measures are 0 , like below -
How can I only show the rows no when only having values in measures.
Extra Notes :
The other measures contdition used - GetSelectedCount(_measures) > 0 AND SubStringCount('|' & Concat(_metricsNo, '|') & '|', '|100|')
Defination - if(rowno(total)<=1000,Sum([fieldname]))
Thanks
rowno() is just to add sequential row numbers to the table
try as below
=if( (measure1 + measure2 + measure3 + measure4) >0 ) , measure1)