text and case sensitive

[delbooth]

Hi.

I would like to sum a field Quantity_ Collected from the field Account_Name which can have the text 00012 PAUL or 00012 paul so it gives me a sum for Paul ignoring the fact some are in upper and some lowercase.

Thanks

Del

[christophebrault]

Hi,

If possible, the goodway to do this is to Upper or Lower your Account_Name in the script

Lower(Account_Name) as Account_Name

[agigliotti]

you can use the below calculated dimension:

Upper(dimension_name)

[lironbaram]

hi

you can use Upper() function on your field

so all text will be in upper case for this function

[PrashantSangle]

use wildmatch()

Regards,

[Chanty4u]

try may be

Capitalize(lower(field))

or

Capitalize(upper(field))

[delbooth]

Thanks for that, I have now all text in capitals.  To finish it off how do I sum Account_Number that contains the text PAUL when it can be 00012 PAUL, 0014 PAUL, 0015PAUL in the field.

I have tried

Sum({<[Account Number]= {'*PAUL*'}>} [Quantity Advised])

[OmarBenSalem]

put it btwn double quotes; it will work wether it's upper or lower case

Sum({<[Account Number]= {"PAUL"}>} [Quantity Advised])

[OmarBenSalem]

please refer to :

Quotes in Set Analysis