Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
you can use the below calculated dimension:
Upper(dimension_name)
hi
you can use Upper() function on your field
so all text will be in upper case for this function
use wildmatch()
Regards,
try may be
Capitalize(lower(field))
or
Capitalize(upper(field))
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])
put it btwn double quotes; it will work wether it's upper or lower case
Sum({<[Account Number]= {"PAUL"}>} [Quantity Advised])
please refer to :