Dear Experts,
Help required to evaluate the following expression so that it will eliminate MaxID=41483 from selection and get only 'Max' field value in column.
Using following formula
Activity Count=Count({< MaxID = {"='>=' & 'Max' & '<=' & 'Max'"}>}{<Doc_Date = {">=$(vStartDate)<=$(vEndDate)"}>} EQUNR_S)
| Activity Status | EQUNR_S | MaxID | Doc_Date | Activity Count |
| Surplus | 20432 | 41483 | 07.08.2014 | 1 |
| Under decommissioning | 20432 | Max | 17.08.2014 | 1 |
Thanks
Ashif
