Refer to thisRow using a Canvas Based Formula

1

Sequence(2,[AHJ Cycle Adoptions Data Per Publication].[List of Effective Dates].count()).FormulaMap(CurrentValue.WithName(i,([AHJ Cycle Adoptions Data Per Publication].[List of Effective Dates].Nth(i-1).ToNumber() - [AHJ Cycle Adoptions Data Per Publication].[List of Effective Dates].Nth(i).ToNumber())*-1))

I have this canvas based formula above. [AHJ Cycle Adoptions Data Per Publication].[List of Effective Dates] should refer to each row in the table ‘AHJ Cycle Adoptions Data Per Publication’. How will I do that?

2

Any chance you can post an example doc?

1 Like
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.