null values

[master_student]

Hello Guys,

I have a field that displays 0, i need to supress these values :

i checked supress null values in the presentation Tab

Here is my SLA Globale formula :

=Interval(Sum({<[Code Cas] = p({<[Statut Cas] = {'Fermé crédit', 'Fermé-remboursé', 'Fermé activation', 'Fermé BO', 'Fermé DT', 'Fermé Rétention', 'Fermé Rétention Client Perdu', 'Fermé Rétention Client Retenu'}>})>}TOTAL <[Code Cas], [Date création], [Statut Cas], PROVIDER_GRP_ID> Interval#(SLA_GLOBAL, 's')), 'm')

[Anil_Babu_Samineni]

One funny Solution

If([SLA Globale] >0, Interval(Sum({<[Code Cas] = p({<[Statut Cas] = {'Fermé crédit', 'Fermé-remboursé', 'Fermé activation', 'Fermé BO', 'Fermé DT', 'Fermé Rétention', 'Fermé Rétention Client Perdu', 'Fermé Rétention Client Retenu'}>})>}TOTAL <[Code Cas], [Date création], [Statut Cas], PROVIDER_GRP_ID> Interval#(SLA_GLOBAL, 's')), 'm'))

[master_student]

didn't work, i always have 0 values on SLA Globale

[vineetadahiya12]

Hi,

If you are using a straight table, under Presentation tab there is an option to Supress Zero-Values.

This would help you.

[master_student]

yes I did that but didn't works

[Chanty4u]

try

=if(Measure<>0, Dimension, Null())

[master_student]

didin't work

[prma7799]

Please share some sample app

or try

=if(len(SLA Globale )=0, Dimension, Null())