Condition in dimension

[#1]

Hi,

In the Background Color property of a dimension i apply this condition :

=if (Sum({$ <[Type adhérent]={Collectif}, Année=>} NB_ADH_RAD_NETTE)<1

and Sum({$ <[Type adhérent]={Collectif}>}NB_ADH_PORTEFEUILLE) = Sum({$ <[Type adhérent]={Collectif},

REIMMATRICULATION={NON}, Année={$(vAnnée)} >} NB_ADH_PROD_NETTE) , RGB(255,0,0))

It works fine for the backgrounbd color.

But i don't know how to apply this condition to the dimension : only the values that apply this condition appear.

Thanks and sorry for my english.

[whiteline · Accepted solution]

Hi.

You don't provide the name of field for that dimension.

Try to use something like this  as calculated dimension:

=aggr(if(Sum({$ <[Type adhérent]={Collectif}, Année=>} NB_ADH_RAD_NETTE)<1 and

           Sum({$ <[Type adhérent]={Collectif}>}NB_ADH_PORTEFEUILLE) =

           Sum({$ <[Type adhérent]={Collectif}, REIMMATRICULATION={NON}, Année={$(vAnnée)} >}NB_ADH_PROD_NETTE) , [Your dimension field name], null()), [Your dimension field name])

[#3]

Hi,

Here what i've done :

=aggr(if(Sum({$ <[Type adhérent]={Collectif}, Année=>} NB_ADH_RAD_NETTE)<1 and

          Sum({$ <[Type adhérent]={Collectif}>} NB_ADH_PORTEFEUILLE) =

          Sum({$ <[Type adhérent]={Collectif}, REIMMATRICULATION={NON}, Année = {$(vAnnée)}>}NB_ADH_PROD_NETTE) , PARTENAIRE, null()), PARTENAIRE)

It works fine.

Thanks a lot.