SubItem#Count Issues

Platform discussions Special workflows & use cases
,
1

I am trying to perform a calculation, but only if there are subitems for a item.
IF(
AND({SubItem#Count} > 0, {Points} > 0),
({Points} /{SubItem#Count}),
{Points}
)

The logic appears to work fine, because when I replace the division with “true” and {Points} with “false” it prints out as I would expect.

But, with the division in there I get errors about “invalid parameter” and “can’t divide by 0”.

image

Everywhere it says false, it should pull in the left column.

Right most column is just this formula:
IF(
AND({SubItem#Count} > 0, {Points} > 0),
“true”,
“false”
)

2

@rbuckley

Try this instead:

IF( AND({SubItem#Count} > 0, {Points} > 0), DIVIDE({Points} ,{SubItem#Count}), {Points})

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Keep your Integromat scenarios from timing out! - YouTube
Contact me directly here: Contact – The Monday Man