Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All ,
Can some one explain what the beow expression is doing ?
=Alt(Count({$<
DueDate= {">=$(vDD11MonthBack)<=$(vDueEndDate)"}
>}
[Log User]),0)
Thanks
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
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