Hello dear community,
I use the same expression in a pivot table and in a text object :
=count( //if(IsNull(MAT)='0',
if(day(date([Date Dern. modif.],'DD/MM/YYYY'))>=day(date(Today()-1,'DD/MM/YYYY'))
and month(date([Date Dern. modif.],'DD/MM/YYYY'))>=month(date(Today()-1,'DD/MM/YYYY'))
and Year(date([Date Dern. modif.],'DD/MM/YYYY'))>=Year(date(Today()-1,'DD/MM/YYYY')),
if(LONG_DESC_STATUS='Fermé crédit'
OR LONG_DESC_STATUS='Fermé-remboursé'
OR LONG_DESC_STATUS='Fermé activation'
OR LONG_DESC_STATUS='Fermé BO'
//OR LONG_DESC_STATUS='Fermé DT'
//OR LONG_DESC_STATUS='Fermé BO-Non Traité'
OR LONG_DESC_STATUS='Fermé BO Non Traité'
OR LONG_DESC_STATUS='Fermé Rétention'
OR LONG_DESC_STATUS='Fermé Rétention Client Perdu'
OR LONG_DESC_STATUS='Fermé Rétention Client Retenu'
OR LONG_DESC_STATUS='Fermé Support VAS'
OR LONG_DESC_STATUS='Fermé – Doublon'
OR LONG_DESC_STATUS='Abandonné'
OR LONG_DESC_STATUS='Fermé Support VAS-Rejeté'
OR LONG_DESC_STATUS='Rejeté',CASE_ID)))
The pb is the amout displayed is not the same in the two graphs :
In the pivot table, I have a condition on a field. probably this condition is causing the gap (supprimer si valeur est nulle est coché)
=if( [Type Acces] = 'Mobile' and [Entité] = 'BO B2C',[Dern. modif par],
if ([Type Acces] ='Fixe' and [Entité] = 'Fixe B2C', [Dern. modif par])
)
I need to have the same number as the pivot table.
Thanks for your help.