Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi @a2ztests ,
Maybe this:
=sum( {< YearQuarterKey = {"$(=Max(YearQuarterKey)-1)"} >} account_score)
I hope it can helps.
Best Regards
Thanks,
I want to show for every row! in the table the previous score so i think comparing it to
$(=Max(YearQuarterKey)-1)
Will not do what i want.
Any other thoughts?
Thanks again
You can try using Above( Sum(account_score) ) if your table is sorted by YearQuarterKey field.
That expression give you the Sum(account_score) of the previous table row.
Best Regards