I’m hoping someone can help troubleshoot why a conditional rollup is returning a zero “0” value.
Table 1 has a list of vehicles.
Table 2 records all certification renewals. There’s about a dozen different certifications required per vehicle, with varying expiry dates.
I have a linked field in Table 2 connecting each certification expiry with a specific vehicle in Table 1.
I have a helper column in Table 2 that filters the date for a specific certification type.
I’m trying to run a Conditional Rollup in Table 1, that returns the MAX(values) from the helper column in Table 2.
But it’s returning a zero “0” figure.
Any pointers would be appreciated.