i'm trying to show arrows next to my calc . I have Field1 field which has 100+ values , based on my date selection I want to compare current month number with previous month and show arrow based on changes between current and previous month. This is the expression I am using but it is not providing the results. Any help is appreciated
if(
(count({$<Field1=,
MonthYear={$(='"'&concat(distinct date(Addmonths
(MonthYear,-Getselectedcount(MonthYear)) ,'MMM-YYYY') ,'","') &'"')} >} [Identifier]) > 0
OR count({$<Field1=,[Date]={">$(varMinSelectedDate)<=$(varSelectedDate)"}>} [ Identifier]) > 0
),
// if ((count({$<MonthYear={$(='"'&concat(distinct date(Addmonths(MonthYear,-Getselectedcount(MonthYear)) ,'MMM-YYYY'),'","')&'"')},Field1=>} [Recipient Identifier]))
// - (count({$<[Date]={">$(varMinSelectedDate)<=$(varSelectedDate)"},Field1=>} [ Identifier])) = 0,
if(
(count({$<Field1=,MonthYear={$(='"'&concat(distinct date(Addmonths
(MonthYear,-Getselectedcount(MonthYear)) ,'MMM-YYYY'),'","')&'"')}>} [Identifier]) =
count({$<Field1=, [Date]={">$(varMinSelectedDate)<=$(varSelectedDate)"}>} [ Identifier])
),'resize horizontal icon',
if(
(count({$<Field1=,MonthYear={$(='"'&concat(distinct date(Addmonths
(MonthYear, -Getselectedcount(MonthYear)) ,'MMM-YYYY'),'","')&'"')}>} [Identifier])>
count({$<Field1=, [Date]={">$(varMinSelectedDate)<=$(varSelectedDate)"}>} [ Identifier])
),'arrow down icon','arrow up icon'
)
)
)
