I tried all kinds of ways, but I can’t get it to work.
I want to combine a lookup field (containing multiple currency values) with a placeholder symbol (e.g. “;” ) so that I can then in the next step substitute this placeholder for a line break so th...
I’m trying to achieve the following:
If Invoice Status is ‘Paid’, then ‘Paid’
If Invoice Status is empty and the date in Payment Due is on or after today, then ‘Due’
If Invoice Status is empty and the date in Payment Due is before today, then ‘Overdu...
I think I have solved it!
The problem was that the {Incl Tax} field was a formula field, which caused an error in the FIND formula in the next step.
My solution was to create a field called {Incl Tax concatenated} and then concatenate the {Incl Tax} ...
I got one step further and managed to get the amounts correctly when they finish on one zero. But the other ones (ending on two zeros or no zeros) still give an error.
This is what the formula looks like now:
"$" & IF(FIND(".", {Incl Tax}) = 0, {Incl...
Thanks so much for this Gwynn! This does take me in the right direction!
I’m not quite there yet though, because in my table the output is different. I get an error for amounts that end on .00 or on two numbers after the decimal separator. And for am...
Thanks for your reply Gwynn! :slightly_smiling_face:
The addition of the line break happens in a different field in the next step, in a different formula. So it’s not applicable to the problem with the ARRAYJOIN formula not showing the currency for...
