Error using RowId(CurrentValue)

Coda seems to get grumpy when using RowId(CurrentValue), but it tends to comply anyway.

Is there a better way to do this, or is it okay to just roll with it?

Could you elaborate on what you are trying to do?

Hey Piet!

Here’s an actual formula example. In this one I’m essentially calculating the outstanding commission balance for a certain affiliate based on All Commissions Earned - Commission Payouts Made:

[Attributed Sales].Filter(Ambassador=thisRow.Ambassador).[Calculated Commission].Sum() - [Commission Payout].Filter(Ambassador=thisRow.Ambassador AND CurrentValue.RowId()<=RowId(thisRow)).[Amount Paid].sum()

To clarify, I’m aware that I could create a column dedicated to RowId and that would likely satisfy Coda - I’d just prefer not to add more columns if possible.

Hi Patrick,

Have a look at the little icon next to ambassador, it shows that it is a whole row. You are comparing that to the single value rowid().

Hence the error message that the types are incompatible. I’m unfortunately not at a laptop at the moment, but you need to ensure that the left side of the comparison is a specific field. I am not certain that you actually need the “AND current value…”. You have already filtered to Ambassador.

Regards
Piet.