I have this column “defesa” that aggregate the year of post-graduation degree from Master and PhD.
Which is created with:
values = [c.Defesa for c in Formacao.lookupRecords(Orientando=$id) if c.Defesa] return list(set(values))
I would like to have another column that calculates the gap between the years. Something like:
if len(defesa)=2 gap = "year1" - "year2" return gap
Is it possible?
Thanks in advance!