J_JBA - profile

J_JBA · Aug 10, 2020

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...

J_JBA · Aug 08, 2020

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...

J_JBA · Aug 17, 2020

Thanks Justin, good to know! :slightly_smiling_face:

J_JBA · Aug 12, 2020

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} ...

J_JBA · Aug 11, 2020

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...

J_JBA · Aug 11, 2020

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...

J_JBA · Aug 10, 2020

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...

User Statistics

User Activity

Currency format in formula field

IF/AND statement with Date TODAY

Re: Currency format in formula field

Re: Currency format in formula field

Re: Currency format in formula field

Re: Currency format in formula field

Re: Currency format in formula field