Need to show row nos only when all the measures values are greater that 0

ashmitp869 — Fri, 21 Oct 2022 03:20:57 GMT

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

Re: Need to show row nos only when all the measures values are greater that 0

vinieme12 — Fri, 21 Oct 2022 08:36:56 GMT

rowno() is just to add sequential row numbers to the table

try as below

=if( (measure1 + measure2 + measure3 + measure4) >0 ) , measure1)