Skip to Content
avatar image
Former Member

Webi logic

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 12, 2017 at 03:13 PM

    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

    Add comment
    10|10000 characters needed characters exceeded