Count of Expression

[kakani87]

Dear All,

There is an expression with me which to display with a Image/Symbol now what i want is to display is the count where it is displaying the image//Symbol Following is the expression

if

(

count

(

{<

CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},

InOut={0}

>}

InOut

)

<>

count

(

{<

CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},

InOut={1}

>}

InOut

)

,

'qmem://<bundled>/BuiltIn/minus_r.png'

)

[sunny_talwar]

When you say all, you mean sum the number of days? So Day won't be a dimension when you see this?

[sunny_talwar · Accepted solution]

Something like this

Try this

Sum(Aggr(if(count({<

CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},

InOut={0}

>}InOut)

<>

count({<

CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},

InOut={1}

>}

InOut ),1,0), Location, DepartmentName, EmpName, tran_date))

[kakani87]

This  meets my requirement let me check and update.