Hi, I am creating a query that measures the % cash in a portfolio by taking the value of cash they have and dividing it by the total portfolio value. In the query, the results come out as a 15 digit decimal, some doing the 2.345E-2 and such. How do I format this to either show a % or at least get rid of the E-2 functions?
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.