Mod formula assistance

[Project_NP_LS]

I am trying to understand a why a simple MOD function isn’t returning the correct answer.

Airtable

Airtable: Organize anything you can imagine

Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.

( I can grant you access so you can see the formulas)

On the table titled “SEASON STATS OVERVIEW”, in the OVER field, I am trying to build a larger formula and part of it requires me to use the MOD function. The formula in the OVERS field is MOD({BALLS BOWLED},6) but for some reason the record for player 2 is returning a value of 6 when it should be 0. I have tested the MOD function for the number 30 as a number i.e. not generated from a roll up function and that works. But for some reason when the number 30 is generated from a Roll up formula is returns an incorrect value.

I can grant creator access to you if you need to see the formula fields/

Any ideas/assistance, all gratefully received.

Thanks in advance

[ScottWorld]

@Justin_Barrett, it looks like the formula worked without needing to go through your workaround of converting the rollup field into a string, and then a value. Does this mean that Airtable now works properly when applying the “MOD” function to rollup fields?

[Justin_Barrett]

ScottWorld:

Does this mean that Airtable now works properly when applying the “MOD” function to rollup fields?

I don’t think it’s a case of it working properly “now” vs some other behavior in the past. My impression is that the output of a Rollup field depends on the aggregation formula used. It wouldn’t make sense for SUM(values) to return an array. Same thing for MIN(values) and MAX(values). However, some aggregation functions will still create arrays. In short, it’s a case-by-case situation.

[Project_NP_LS]

this is brilliant. thank you very much indeed.

[Project_NP_LS]

thank you as well for taking the time to figure out the solution. Again, much appreciated.

[ScottWorld]

Justin_Barrett:

I don’t think it’s a case of it working properly “now” vs some other behavior in the past. My impression is that the output of a Rollup field depends on the aggregation formula used. It wouldn’t make sense for SUM(values) to return an array. Same thing for MIN(values) and MAX(values) . However, some aggregation functions will still create arrays. In short, it’s a case-by-case situation.

Great, thank you! :slightly_smiling_face: