AnsweredAssumed Answered

Conditional value list returns values

Question asked by OliverMartin on Jul 7, 2015
Latest reply on Jul 8, 2015 by OliverMartin

Title

Conditional value list returns values & "?"

Post

Hi,

I have two tables: Loads and Vehicles

Loads contains a list of dates and a list of vehicles IDs. There is a relationship between the two based on the Vehicle ID.

I want to count the number of days a vehicle runs for, but as it might do anything from 1-4 loads per day (also 0 loads, but then there would be no load record)  I need to count only unique instances.

I have created a value list a conditional value list, starting from Vehicles that lists all the delivery dates.

But when I test this value list from the Vehicles table, it contains some of the dates, but not all, and the last value is always a "?"

 

Untitled.png

Outcomes