if condition

[surajap123]

Hi All,

In my existing if condition, i want to display only field(ID) value greater than 10. Below is the expression i am using and i want to modify it to show values >10.

count(if(

  (FromDate >= Weekstart and FromDate <= Weekend) or

  (ToDate >= Weekstart and ToDate <= Weekend) or

  (FromDate <= Weekstart and ToDate >= Weekstart) or

  (FromDate <= Weekend and ToDate >= Weekend) , ID))

[SunilChauhan · Accepted solution]

try this in expression

if(count(if(

  (FromDate >= Weekstart and FromDate <= Weekend) or

  (ToDate >= Weekstart and ToDate <= Weekend) or

  (FromDate <= Weekstart and ToDate >= Weekstart) or

  (FromDate <= Weekend and ToDate >= Weekend) , ID))>10,

count(if(

  (FromDate >= Weekstart and FromDate <= Weekend) or

  (ToDate >= Weekstart and ToDate <= Weekend) or

  (FromDate <= Weekstart and ToDate >= Weekstart) or

  (FromDate <= Weekend and ToDate >= Weekend) , ID)))

[surajap123]

Hi Sunil,

This expression is working. I will test it in my main dashboard and come back by evening. Thanks !!

[surajap123]

Thanks everyone for your support !!