Syntax Help

[regowins]

Hi,

I need help with syntax in a chart exprssion.

The original fields used to be  Ledger_Amt_USD and Ledger_Amt_Base 

There is also a field called Currency_Field which has two values,  BASE & USD.

The chart expression use to be   Ledger_Amt_ $(=minstring(Currency_Field))   ....puts 'base' or 'usd' at the end of ledger_amt based on selection.

I had to change Ledger_Amt_USD to [Ledger Amt USD] and Ledger_Amt_Base to [Ledger Amt Base]. Is it possible to add 'Base' and 'USD' based on selection like before?

Thanks! 

[swuehl]

Just give it a try:

[Ledger Amt $(=minstring(Currency_Field))]

The dollar sign expansion should work out also with your new field names.