cancel
Showing results for 
Search instead for 
Did you mean: 

Upper Case of Fields

0 Kudos

Hi All,

I have different 7 (e.g A, B, C, D, E, F) fields where I need to change case of words from small to Upper, so my question is instead of creating different variable for different fields can we use one formula for different fields.

e.g = Upper(A,B,C,D,E,F)

I had tried "InList","And" and "OR" function also but no luck. Please suggest.

For time being i have created 7 different variables for report.

Regards,

Amit R. Lonkar.

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Done Thanks

rajan_burad
Active Participant
0 Kudos

Hi Amit,

There is no need to create a variable as directly you can use UPPER() function for all dimensions.

Also as per your requirement Upper(Field No.1,Field No.2,Field No.3) as far as I know it's not possible.

Thanks,

Rajan 🙂

rajan_burad
Active Participant
0 Kudos

Hi Amit,

For every field you can use UPPER directly, no need to create a separate variable for all fields.

UPPER(Dimension)

Let us know if it helps in your scenario.

Thanks 🙂

0 Kudos

I didn't get correct clarity .... i had used same thing which you mentioned... UPPER(Dimension)

for 1 field = Upper(Field No.1), Upper(Field No.2), Upper(Field No.3).... this type I had already created variables but i dont want like this... can we make one formula like =Upper(Field No.1,Field No.2,Field No.3)