topic Re: Conditions in table's dimension in App Development

Conditions in table's dimension

danimarc12 — Tue, 06 Dec 2022 21:59:41 GMT

Hello everyone!

I have an issue with my App. I want to display my first column Clienti with the condition that Saldo periodo and Saldo prec are <> 0. So my expected records should be seven.

How can I set a condition in a dimension?

I've tried as you can see

but I display an error

Could anyone help me?

Thanks to all!

Re: Conditions in table's dimension

joseph_morales — Wed, 07 Dec 2022 01:08:32 GMT

Hi @danimarc12 ,

You can try this:

Aggr(

if( conditions, cliente_c)

,cliente_c)

Re: Conditions in table's dimension

vinieme12 — Wed, 07 Dec 2022 06:45:00 GMT

Add a calculated dimension as below

= AGGR( if( ExpressionForSaldoPre>0 and ExpressionForSaldoPeriodo > 0 , Clienti) , Clienti )

uncheck show null values for this dimension