Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an expression in a text object, like below:
=num
(sum({$<PeriodCounter={">$(#=max(PeriodCounter-3))<=$(#=max(PeriodCounter)-2)"}, YearMonthNum=,Year=>}SickTime*+1)
/
sum({$<PeriodCounter={">$(#=max(PeriodCounter-3))<=$(#=max(PeriodCounter)-2)"}, YearMonthNum=,Year=>}WorkTime)+1
, '# ##0,0%')
And when I do a selection in a list box for YearMonthNum I don't wont the expression to affect to expression.
I have try to include the field "YearMonthNum=" in the expression and also change $ to 1 but it does't work.
If I exlude the filter with PeriodCounter it works.
Any suggestions?
May be you needed it within the inner Max() function as well. Try this:
=Num
(Sum({$<PeriodCounter={">$(#=max({<YearMonthNum, Year>}PeriodCounter-3))<=$(#=max({<YearMonthNum, Year>}PeriodCounter)-2)"},YearMonthNum=,Year=>}SickTime*+1)
/
sum({$<PeriodCounter={">$(#=max({<YearMonthNum, Year>}PeriodCounter-3))<=$(#=max({<YearMonthNum, Year>}PeriodCounter)-2)"}, YearMonthNum=,Year=>}WorkTime)+1
, '# ##0,0%')
May be you needed it within the inner Max() function as well. Try this:
=Num
(Sum({$<PeriodCounter={">$(#=max({<YearMonthNum, Year>}PeriodCounter-3))<=$(#=max({<YearMonthNum, Year>}PeriodCounter)-2)"},YearMonthNum=,Year=>}SickTime*+1)
/
sum({$<PeriodCounter={">$(#=max({<YearMonthNum, Year>}PeriodCounter-3))<=$(#=max({<YearMonthNum, Year>}PeriodCounter)-2)"}, YearMonthNum=,Year=>}WorkTime)+1
, '# ##0,0%')
Try addding it to the max functions too:
=num
(sum({$< PeriodCounter={">$(#=max({<YearMonthNum=,Year=>}PeriodCounter-3))<=$(#=max({< YearMonthNum>}PeriodCounter)-2)"},YearMonthNum=,Year=>}SickTime*+1)
/
sum({$<PeriodCounter={">$(#=max({<YearMonthNum,Year=>}PeriodCounter-3))<=$(#=max({<YearMonthNum,Year=>}PeriodCounter)-2)"}, YearMonthNum=,Year=>}WorkTime)+1
, '# ##0,0%')