Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi. I have a dataset with the fields: Account_id, account_score, year_quarter, YearQuarterKey (which is a running sequencial number for every year-quarter combination). I want to use set analysis in a table presentation on my app, and to add the field previous_quarter_score to every row ! in the table, according the field YearQuarterKey I tried: =max( {< YearQuarterKey = {"$(=(YearQuarterKey-1))"} >} account_score) It did not work. Any thoughts on how to accomplish this? Thanks
Try Above function;