I have a database with a currency Amount column I’m trying to sum up. When I do sum(DB.Amount), the correct sum is output, but the formula builder throws an error:
Sum expects parameter value to be a number, a list of numbers, a formatted number, a list of formatted numbers, a percentage, a list of percentages, a currency amount, a list of currency amounts, a time duration, or a list of time durations, but found [DB].Amount, which can match a column, or a list of text values
I’ve checked manually and all items in the column are either numeric or blank. Also, when I enter just DB.Amount into the formula builder, the UI tells me that it’s a “list of currency values”, though the chip for Amount has a “T” text icon next to it for some reason.
would it be possible for you to post a copy of doc (with data manipulated)?
something like this is granular and specific and easier to troubleshoot/see all columns in context.
alternatively, a formula like .ToNumber(), may or may not help in your scenario.
Thanks! I tried to replicate the doc and redact the data, but wasn’t able to replicate the behaviour. Here’s a screenshot illustrating the problem more clearly - perhaps it helps:
Hovering over the [$] icon, it says that this outputs a list of currency amounts - but that’s not what the icon on the green chip says, and when I try to do the following formula I get the error described above.
I’ve checked (formulaically) and there are no text entries in the column – every row is either a number or blank.
What is strange is that the Sum() formula leads to an output which seems like the correct number, but there is still that error in the formula editor interface.
I was able to resolve this by selecting the whole Amount column, and copying the values into a fresh currency column I created. Not sure what was behind this bug, though. Thanks for the suggestions!