X[Min:y] doesn't return results consistently
In the first screenshot below, the formula in Min Start Date TEST is trying to get the earliest Activity Start Date by line item Campaign New from the second screenshot. There is no empty date in second screenshot, but the formula returns nothing in the first screenshot. This formula works in most other campaigns in the same module, but returns empty value for only a few campaigns like the example below where no date is empty.
When use the X[Max:y] formula for activity end date, it works fine.
Anyone has encountered similar issues before? Any insights on why this happened for only few instances? Thank you in advance!