6 Replies Latest reply: Jul 1, 2018 9:28 PM by ahmad albab

# How can I display result which is greater than 0?

Dear Friend,

My result display value which include 0 & negative. how to modified my formula to exclude it? Thanks.

Have a nice day :-)

=Count({\$<[SR No]={"=Min ({<Temp = {'Task_1'}>}[Date Created]) >=  MakeDate(2018,1,15)"}>

*\$<[SR No]-={"''"}>

*\$<[Gate]={"Gate C"}>

}

(Gate))-count([SR No])

• ###### Re: How can I display result which is greater than 0?

Put the expression in a variable and use an if condition?

• ###### Re: How can I display result which is greater than 0?

Hi Arjun,

I manage to get the display in table. but how im gonna show the total in KPI object? it showing NaN.Could be due to the text. it should  show 8 instead of NaN.

if(

(Count({\$<[SR No]={"=Min ({<Temp = {'Task_1'}>}[Date Created]) >=  MakeDate(2018,1,15)"}>

*\$<[SR No]-={"''"}>

*\$<[Gate]={"Gate C"}>

}(Gate))-count([SR No]))>0,

(Count({\$<[SR No]={"=Min ({<Temp = {'Task_1'}>}[Date Created]) >=  MakeDate(2018,1,15)"}>

*\$<[SR No]-={"''"}>

*\$<[Gate]={"Gate C"}>

}(Gate))-count([SR No])),

'No repetition')

• ###### Re: How can I display result which is greater than 0?

i think you'll need an aggr function to achieve it.

• ###### Re: How can I display result which is greater than 0?

Dear All,

sum(Aggr(

if(

(Count({\$<[SR No]={"=Min ({<Temp = {'Task_1'}>}[Date Created]) >=  MakeDate(2018,1,15)"}>

*\$<[SR No]-={"''"}>

*\$<[Gate]={"Gate C"}>

}(Gate))-count([SR No]))>0,

(Count({\$<[SR No]={"=Min ({<Temp = {'Task_1'}>}[Date Created]) >=  MakeDate(2018,1,15)"}>

*\$<[SR No]-={"''"}>

*\$<[Gate]={"Gate C"}>

}(Gate))-count([SR No])),

'No repetition') , [SR No]))

• ###### Re: How can I display result which is greater than 0?

in a KPI, try sthing like:

sum({<Yourdim={"=sum(YourMeasure)>0"}>}YourMeasure)