Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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])
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])
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.