Need Ideas to populate this report

[Former Member]

I have a report in which it has fields like Name,Number,Addr and Category now I Category has A,B,C,D(category types) now in my report I should display only data that are of category type B,D.

I am getting fields from the universe to populate the data.

[Former Member · Accepted solution]

Try using record selection formula like

{Category field} like ["B", "D"]

Regards,

Raghavendra

[Former Member]

In case the HTML is messing up the formula for you as well it's as follows:

{TABLE.Category} In \"B\", \"D\";

{TABLE.Category} in

Open square bracket, then double-quote, then capital B, then double-quote, then a comma, then a double-quote, then capital D, then double-quote then close square bracket

[former_member292966]

Hi Sai,

I'd recommend using the Record Selection Formula to filter out the Categories you want like:

{TABLE.Category} In ["B", "D"];

Good luck,

Brian

[Former Member]

I am the same {cat.Category} In \"B\", \"D\";

when i am checking the Syntax it pops out an error msg saying

'A number ,currency amount,string,boolean.. is expected here'

[Former Member]

Try this

{Category field} like ["B", "D"]

Regards,

Raghavendra

[Former Member]

Thanks, raghavendra It worked like a charm