Skip to Content
0

Webi logic

Sep 12, 2017 at 09:34 AM

44

avatar image
Former Member

Hi Team,

I have a requirement in webi I would like to do condition following logic-Categorize materials based on the following logic:

Kindly help me on this how to do achieve this i attached the file.category.jpg

Thanks in advance Guru.

Regards

Vijay















category.jpg (67.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Noel Scheaffer Sep 12, 2017 at 03:13 PM
1

You will need to create a lengthy variable in Web Intelligence with a series of nested If statements following this syntax...

If(bool_value;true_value;false_value)

Category = If(([Val Class] In ("FG20"; "DS10"; "DS20") And ("PH3" = "ROU" Or [PH1] In ("FAU"; "ACC"; "RPT"; "SAN"))); 1; If([Val Class] = "FG20" And [PH1] = "BAT"; 2; Etc.)

If you have control of the universe or can reach out to someone who does this Category logic could be placed there for use by anyone using the universe.

Noel

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Agree with Noel solution.

0