Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I have a measure that returns null values :
I need to remove null values.
Any idea how ?
Here the expression of SLA Globale : =Interval(Sum(TOTAL <[Code Cas], [Date de commande], SLA_GLOBAL, [Statut Cas]> Interval#(SLA_GLOBAL, 's')), 'm')
Thanks
Try simple if
=if( Interval(Sum(TOTAL <[Code Cas], [Date de commande], SLA_GLOBAL, [Statut Cas]> Interval#(SLA_GLOBAL, 's')), 'm') > 0 ,
Interval(Sum(TOTAL <[Code Cas], [Date de commande], SLA_GLOBAL, [Statut Cas]> Interval#(SLA_GLOBAL, 's')), 'm')
)
Are you saying that 0 is essentially null? and you want the second row to go away?
yes
There seems to be other columns (which you might not have included in your screenshot)... are those all 0s? or is there a value within some of them?