This is an example of what I currently have:
var Var1 = "CALCULATION";
var Format = "Format1";
var CurrencySymbol = "Symbol1";
var amount = Field("CALCULATION");
var result = "$0.00";
if (amount != "0") result = "$" + FormatNumber("#,###.00", amount);
return result;
symbol = "";
symbol2 = "";
if (CurrencySymbol == "Symbol1")
{
symbol = "$";
symbol2 = "USD";
}
if (CurrencySymbol == "Symbol2")
{
symbol = "?";
symbol2 = "EUR";
}
if (CurrencySymbol == "Symbol3")
{
symbol = "£";
symbol2 = "GBP";
}
if (CurrencySymbol == "Symbol4")
{
symbol = "¥";
symbol2 = "YEN";
}
function SwitchDelimiter(x)
{
x = ReplaceSubstring(x, ".", "a");
x = ReplaceSubstring(x, ",", ".");
x = ReplaceSubstring(x, "a", ",");
return x;
}
if (Format == "Format1")
return symbol + FormatNumber("#,###.##", Field(Var1));
if (Format == "Format2")
return symbol + SwitchDelimiter(FormatNumber("#,###.##", Field(Var1)));
if (Format == "Format3")
return symbol + FormatNumber("####.##", Field(Var1));
if (Format == "Format4")
return symbol + SwitchDelimiter(FormatNumber("####.##", Field(Var1)));
if (Format == "Format5")
return symbol2 + "" + symbol + FormatNumber("#,###.##", Field(Var1));
if (Format == "Format6")
return symbol2 + "" + symbol + SwitchDelimiter(FormatNumber("#,###.##", Field(Var1)));
if (Format == "Format7")
return symbol2 + "" + symbol + FormatNumber("####.##", Field(Var1));
if (Format == "Format8")
return symbol2 + "" + symbol + SwitchDelimiter(FormatNumber("####.##", Field(Var1)));
if (Format == "Format9")
return symbol + FormatNumber("#,###.##", Field(Var1)) + "" + symbol2;
if (Format == "Format10")
return symbol + SwitchDelimiter(FormatNumber("#,###.##", Field(Var1))) + "" + symbol2;
if (Format == "Format11")
return symbol + FormatNumber("####.##", Field(Var1)) + "" + symbol2;
if (Format == "Format12")
return symbol + SwitchDelimiter(FormatNumber("####.##", Field(Var1))) + "" + symbol2;