Jump to content

AllegraSptbg

Registered Users - Approved
  • Posts

    11
  • Joined

Converted

  • FusionPro Products
    No

AllegraSptbg's Achievements

Rookie

Rookie (2/14)

  • First Post Rare
  • Collaborator Rare
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges

10

Reputation

  1. That's what I was afraid of. Thank you for your help Step.
  2. Sorry Step. I think I copied an old number. The only number that will truly need to be a "1" is the last digit. I am just trying to keep from having to touch the Excel spreadsheet at all and have FusionPro do all of the work. I cannot get the output I want in Excel by converting it "text" without also going through the extra step of formatting the cell to "custom" and changing the type to "01". Here is another example: 4.72E+16 needs to convert to 472001055674610001
  3. Thanks Step. That works, but I need it to add the 1 at the end. Will I be able to modify this code so that the number will display as 472000000000000001?
  4. Should this be posted on a different board?
  5. I have a number in a data column in excel displaying 4.72E+16, but I need it to read 47200000000001001. Currently I am achieving this in Excel by formatting the cells to a Number with 0 decimal places and entering 01 for the type in Custom. Is there a JavaScript in FusionPro to achieve this same result?
  6. Thanks. I am starting to learn some of the fundamentals of JavaScript again. I was able to replace all of that junk script with just that one line.
  7. 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;
  8. Thanks Step. Changing it to 00 worked. This may be a stupid question, but is there any way to import the rules that I created for this job into another job?
  9. Also, would there be any way to set up the script to add .00 after the number if comes in without the 2 decimal places as well?
  10. Thanks Eric that worked perfectly. Step, When I tried adding your argument in the Number to Currency Javascript it returned everything as $0.00.
  11. Newbie here. Thanks for any help. I currently have 10 fields within a database that I will need to convert to currency once imported. Is there anyway to modify the "Number to Currency" rule so that when the number = "0", "$0.00" is returned without affecting any of the numbers that do not = "0"?
×
×
  • Create New...