Post reply

Data coming in from Financial Statements:

  • June 15, 2016 at 11:57 am

    #314496

    On the report a field is populated from a column X whose datatype is int. the problem is we don't if that number is a percentage or a amount, should we put a $ sign or a % sign. For example 25.10 could be $25.10 or 25.10%. is there any workaround

  • June 15, 2016 at 12:12 pm

    #1885233

    Yes, you go back to the data source and figure out whether it's a % or $.

  • June 17, 2016 at 5:53 am

    #1885569

    SQLPain (6/15/2016)

    On the report a field is populated from a column X whose datatype is int. the problem is we don't if that number is a percentage or a amount, should we put a $ sign or a % sign. For example 25.10 could be $25.10 or 25.10%. is there any workaround

    ouch.

    it sounds like you have a poorly named, poorly described column, with integer values and an "implied" decimal point., ie 4662 is 46.62

    I agree, with the previous poster, go to the data designer or the business groups and ask what the column means.

    I've had my share of those situations;

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply