Skip to Content
avatar image
Former Member

Creating my own value set in a column using variable

Dear Experts,

This may sound like a stupid question...but I will ask.

Rather than using query,

I just need to create my own column with my own values in the report.

I try to create my own set of values within the variable formula.

Can anyone show me how to do this...?

Creating Array.png (49.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 31, 2016 at 02:22 PM

    Hi,

    I afraid, WebI does not allow to create data out of thin air, it can only calculate on the data you have given or defined.

    Creating custom SQL would work.

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 31, 2016 at 02:25 PM

    Hi HT,

    Few questions:

    1. What's the requirement to create that sample data?
    2. What are the other columns in the report?
    3. How is this sample data going to be used (in calculations) or other logic(s)?
    4. Is that going to be static data?

    Thanks,

    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded