Code

[smilingjohn]

HI All ,

Can some one explain what the beow expression is doing    ?

=Alt(Count({$<

  DueDate= {">=$(vDD11MonthBack)<=$(vDueEndDate)"}

  >}

  [Log User]),0)

Thanks

[Anil_Babu_Samineni · Accepted solution]

What are these vDD11MonthBack & vDueEndDate

Explanation:-

This expression getting the Count of [Log User] where DueDate >=  vDD11MonthBack and vDueEndDate {Here, It counts the value of [Log User] in between of today and yesterdays date for current selection}

Assume

1) vDD11MonthBack = Today()-1

2) vDueEndDate = Today()

Count({$<  DueDate= {">=$(vDD11MonthBack)<=$(vDueEndDate)"} >}  [Log User])

---

=Alt(Count({$<

  DueDate= {">=$(vDD11MonthBack)<=$(vDueEndDate)"}

  >}

  [Log User]),0)

Finally, if this condition works fine it gives the count or else 0.

Hope this make helpful