Refer to thisRow using a Canvas Based Formula

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?

Any chance you can post an example doc?

1 Like