Hello,
I have a table includes 6 columns and 2 virtural columns [Earliest Date] & [Earliest Model(s) Available] below:
The virtural column [Earliest Date] uses min() function which works perfectly.
The virtural column [Earliest Model(s) Available] trys to find out the earliest date between [1st Date], [2nd Date] & [3rd Date] and then figures out Model(s) name.
What I tried app formula in virtural column [Earliest Model(s) Available] (type: List) but doesn't work properly:
LIST(
ANY(SELECT([1st Model]
, [_THISROW].[Earliest Date] = [_THISROW].[1st Date])),
ANY(SELECT([2nd Model]
, [_THISROW].[Earliest Date] = [_THISROW].[2nd Date)),
ANY(SELECT([3rd Model]
, [_THISROW].[Earliest Date] = [_THISROW].[3rd Date]))
)
Any thoughts on how can I rewrite above formula to get the earlist model(s). Thank you.
@Steve @Joseph_Seddik @Marc_Dillon @Suvrutt_Gurjar @Rafael_ANEIC-PY @Koichi_Tsuji
Solved! Go to Solution.
Hello @LawrenceMa, try this expression:
LIST(
IF([Earliest Date]=[1st Date],[1st Model],""),
IF([Earliest Date]=[2nd Date],[2nd Model],""),
IF([Earliest Date]=[3rd Date],[3rd Model],"")
)
- LIST("")
Hello @LawrenceMa, try this expression:
LIST(
IF([Earliest Date]=[1st Date],[1st Model],""),
IF([Earliest Date]=[2nd Date],[2nd Model],""),
IF([Earliest Date]=[3rd Date],[3rd Model],"")
)
- LIST("")
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |