Changing a Calculated dimension to Upper Case

[aby_alexander]

Hello,

I have a crosstab report in SAC with data as shown below(calculated at report level). First column is value, 2nd is rank and 3rd is a Alphabetical Value based on the rank calculated as ( If "Column2"<21, 'S',(If "Column2"<50,'A','B'))

4.76 1 s

4.53 6 s

3.87 25 a

4.38 8 s

4.57 5 s

The problem i am facing is that i am unable to get the third column values to show in Upper case although i have specified it as upper case in 'Quotes'. I have tried Multiple options but none of them work. What could be the issue or how this needs to be handled.

Regards,

Aby

[venkateswaran_k]

Hi

In your formula use String function Uppercase

 If "Column2"<21, UPPERCASE('S'),(If "Column2"<50,UPPERCASE('A'), UPPERCASE('B'))

Regards,

Venkat

[aby_alexander]

Hi Venkat, I tried the above solution but it just end up returning blank for the column.

Regards,

Aby

[venkateswaran_k]

Sorry, the statement is wrong

Please read as below

( If "Column2" < 21, UPPERCASE('S'), (("Column2" >=21 and <50),UPPERCASE('A'),UPPERCASE('B')))

[venkateswaran_k]

Hi aby_alexander

Had a chance to check with above corrected formula?

( If "Column2" < 21, UPPERCASE('S'), (("Column2" >=21 and <50),UPPERCASE('A'),UPPERCASE('B')))

[VijayetaSharma]

Hello aby_alexander,

Did you tied UPPERCASE('AbC') = 'ABC' function after concatenation of the strings?

https://blogs.sap.com/2020/06/19/new-string-functions-in-sac-bi-calculations/

Thanks,

Vijayeta

[aby_alexander]

Hi Vijayeta, I cannot use the above as it is an in report calculation based on the Rank. I am creating a crosstab report and all i can use is the formula bar for the same.

Regards,

Aby