Adding a number to each value in a column

Question

Hello,

I have:

Column 1

---------

1

2

3

4

5

I need to add 10 to each value under Column 1. What would be the most appropriate way to do it in Analysis column formula?

My desired result:

------

11

12

13

14

15

Will Sum('Column1' by 10) result in the above shown data? Kindly advise.

Thanks,

CV

Gianni Ceresa · Answer

In addition to what Christian said, the "SUM(.... by something)" is like a group by something in SQL, so it's more to get subtotals and things like that.

[Deleted User] · Answer

"yourtable"."yourcolumn" + 10

That's all. See here: http://slc02okg.oracle.com:7780/analytics/saw.dll?Answers&path=%2Fshared%2FOTN%2F%2B10

Prodney / Admin123