How to sum different hardcoded fields in webi

How to sum different hardcoded fields in webi:

Value

800
800
800



.
.
.
.

How to sum the values…? when i am trying to use standard calculation its disable…

Thanks in advance.


yogamalaka :us: (BOB member since 2011-06-21)

Have you created it as a measure variable?


Mak 1 :uk: (BOB member since 2005-01-06)

No, in this report each field is hardcoded


yogamalaka :us: (BOB member since 2011-06-21)

Better you hardcode the sum as well, since the values are hardcode, how does it matters it the sum is calculated on report level or hardcoded. If all values are hardcoded, what this report is about, what data is it fetching form database? Create an object in universe from the columns in database and insert your values there. Now drag that objects, you would get the values derived form database and will be able to apply calculations on this.


deepak21.s :qatar: (BOB member since 2010-09-06)

I have to add the hardcoded values in report level.


yogamalaka :us: (BOB member since 2011-06-21)

As said earlier, you have to hardcode the Sum as well, as anyways you have hard coded values , so Sum is not going to change till you change the hard coded value…


aniketp :uk: (BOB member since 2007-10-05)

Thanq


yogamalaka :us: (BOB member since 2011-06-21)

If you create a measure variable as follows:-

=800

The Sum function will work.


Mak 1 :uk: (BOB member since 2005-01-06)

maybe yogamalaka can’t hardcode the sum as its not clear how many times this value will be repeated. We need more clarification before we can suggest any solution.


tarunteotia :india: (BOB member since 2011-02-16)

True :).

But I can only work with what is given.


Mak 1 :uk: (BOB member since 2005-01-06)

Actually i have sectioned the report by One element. So that these variables repeat in every block. Finally i added all the hard coded values. Is that makes sense.


yogamalaka :us: (BOB member since 2011-06-21)

Yes in your case , only that can be done as the numbers are hard coded and random.


aniketp :uk: (BOB member since 2007-10-05)