Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 29, 2024 04:52 AM - edited Mar 29, 2024 04:54 AM
Hey guys,
I'm having trouble using a valuta like € 1.333,61 in a formula. It's being recalled from another table using a Lookup field. I've tried adding a new formula column/field and reformatting it first, before using it in a formula, but without any success so far. I keep getting the NaN error when using the value in a formula. All other fields/data in the calculation are valuta's like € 1.333,61 as well. Can you guys give me a hint?
Thanks!
Mar 29, 2024 07:59 AM
Hmm, can you provide screenshots of your tables as well as the formula you're using that's giving you an error please?
I'm able to multiply a lookup of a currency field like so:
Mar 30, 2024 02:39 AM - edited Mar 30, 2024 02:41 AM
Hi @TheTimeSavingCo Adam, thanks for looking into this!
Sharing is a bit difficult, because there are confidential names in there 😊 But here is a formula causing NaN errors. (I blurred out a name in the screenshot)
2 fields with valuta and the 3rd one is Lookup field with valuta.
Mar 30, 2024 07:29 AM
Hm, summing a lookup and two currency fields works fine too:
Without a screenshot it's pretty hard to troubleshoot as I'm pretty much guessing what your setup is and what could be causing the issue I'm afraid, sorry! Perhaps you could recreate the issue on another base or something?