Field in the ValueLoop() function

[#1]

Hello all,

I would like to ask you if it possible for me to somehow have fields in ValueLoop function.

I want to create dimension that will be used as a date.

= ValueLoop(PlannedStart,PlannedEnd,1) something like this

And is it possible to format this as a date, because like this is not working: =Date(ValueLoop(42331,42341,1),'DD.MM.YYYY')

Thanks

[tresesco]

• = ValueLoop(PlannedStart,PlannedEnd,1)  - is poosible provided your fields have only one value in the scope (or selected).
• Date(ValueLoop(... - seems not working

[HirisH_V7]

Hi,

Your Dimension is ok:

ValueLoop(PlannedStart,PlannedEnd,1)

Expression should be ,

=Pick( Match(ValueLoop(PlannedStart,PlannedEnd,1) ,Date(PlannedStart,'DD/MM/YYYY'),Date(PlannedEnd,'DD/MM/YYYY'))

HTH,

Hirish

[marcus_sommer]

Here is a workaround: using ValueLoop with date

- Marcus