Quick Math

shiner03's Avatar


23 Mar, 2018 05:25 AM

I followed Angie Rauscher's post about quick math but can't seem to get it to work. I type in 14.99t, then tab to the next field, but that field remained !4.99. What am I missing. I saw the Currency/Security History screenshot and made mine identical to it. Can you also post what the "Edit Currencies/Exchange Rates" window should look like? How did you set this currency so that t = $1.07? I guess I need step by step instructions to complete this quick math workaround. Thanks

  1. 1 Posted by dwg on 23 Mar, 2018 05:34 AM

    dwg's Avatar

    did you leave a space between the number and the letter t?

  2. 2 Posted by shiner03 on 23 Mar, 2018 02:27 PM

    shiner03's Avatar

    THAT WAS IT. Thanks. It is so frustrating that these small details are not included when these informational posts are written. Ugh

  3. 3 Posted by dwg on 23 Mar, 2018 08:38 PM

    dwg's Avatar

    The example Angie gave did have a space in it :)

    In computing a space is often used as a delimiter, hence it is rare to see it specifically mentioned as being significant. So here the space is used as a delimiter between the amount and an action to be taken, without the space you just have a text string and as a numeric field the appended letter is invalid, so the software can take two possible approaches - drop the alpha character or enter nothing into the field at all. it appears it takes the approach that the added letter was a mistake (high probability with my keyboard skills) and should be ignored.

  4. System closed this discussion on 22 Jun, 2018 08:40 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac