Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
)
When you say all, you mean sum the number of days? So Day won't be a dimension when you see this?
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))
This meets my requirement let me check and update.