Hi All Thanks for inviting me. Lucky I encountered an issue, would have never found this community otherwise. I am at a loss. I try to calculate the remaining amount on an item via saved search. I was able to pull all the necessary information, including the amount from the bills in connection with the item. The field in the "Results"-subtab is called "Billing Transaction : Amount (Foreign Currency)", I cannot find that field in the Records Browser or anywhere on Google. Does anyone know how I can use the value of that field in a formula? Many thanks in advance.

Billing Transaction : Amount (Foreign Currency) Looks like a join. The field is

fxamount

, but joined to another transaction.

Hi Edgar, That already helps a lot. Thank you very much. Would you know what the field for Billing Transaction is?

What kind of Saved Search is it?

Transactions

Maybe

{billingtransaction.fxamount}

Thats how the UI shows the field when you use the formula builder in a Saved Search

Hi Edgar You are a life-saver. Thanks