Using a decimal/valuta from a Lookup field in a formula

[RVB]

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! 

[TheTimeSavingCo]

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:

[RVB]

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.

[TheTimeSavingCo]

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?