
Re: Divide by number of days remaining in the week
Ajay Krishnan Prabhakaran Mar 5, 2014 12:53 PM (in response to Jennie Elliott)Hey Jennie,
Just a suggestion. So the caption expression seems to be working fine right.
(Sum({$<CurrentPeriodWeek={1}, FutureDate={1} >}WorkDayCounter)+1) =4 which would change everyday. Say today this is 4 so the required expression would be
(Column(2)Column(1))/4
Tom this would be
(Sum({$<CurrentPeriodWeek={1}, FutureDate={1} >}WorkDayCounter)+1) =3 and required expression :
(Column(2)Column(1))/3
Is this correct?

Re: Divide by number of days remaining in the week
Jennie Elliott Mar 5, 2014 1:00 PM (in response to Ajay Krishnan Prabhakaran)Yes, you are correct

Re: Divide by number of days remaining in the week
Jennie Elliott Mar 5, 2014 1:08 PM (in response to Ajay Krishnan Prabhakaran)I think I figured it out... my expression is:
(Column(2)Column(1))/Sum({$<CurrentPeriodWeek={1}, FutureDate={1} >}Total WorkDayCounter)+1)
Does that make sense?

Re: Re: Divide by number of days remaining in the week
Ajay Krishnan Prabhakaran Mar 5, 2014 1:15 PM (in response to Jennie Elliott)You would have to store this in a variable and then use it in the expression.
Please go to Settings > Variable Overview > Add
vDate
= Sum({$<CurrentPeriodWeek={1}, FutureDate={1} >}Total WorkDayCounter)+1)
Note: The '=' sign is important
Now,
The expression would be
(Column(2)Column(1))/$(vDate)
To test vDate,
Please put it in a text box and see if its showing the right value.
=$(vDate)

