BusinessObjects Board

Want to count data using the values entered in UserResponse

building reports webintelligence legacy
#1

Anyone please?

When I use UserResponse(“Enter values:”) and display it in report, it looks like this, for example

aaaa;bbbb,cccc

That is fine. Problem is I want to count based on each value seperately .

When I use match function in sum function, sum(match(“aaaa”;UserReponse(“Enter values:”))), it will match against the whole string aaaa;bbbb,cccc, so it will return 0.

Do anyone know how to solve this?

Eva-Mari (BOB member since 2016-09-08)

#2

You’d need to bring in the item that you’re filtering on.

#3

If you want to know the number of values entered in the User Response, why not count the number of semi-colons and add 1?

Norm Rosen :us: (BOB member since 2002-07-10)