Smartlist Builder: How to create calculated columns based on a User Category Value for certain Inventory Items

(0) Share

Report

Posted on by Community Member Microsoft Employee

Create a Smartlist with different columns based on a certain User Category Value. Cannot find = in Mathematical function or IF calculation to use a search criteria.

*This post is locked for comments

All responses (2)

Answers (1)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: Smartlist Builder: How to create calculated columns based on a User Category Value for certain Inventory Items

Thanks Mike. You helped me a lot. Only one more question: which Field Description I have to use in "WHEN"?? From SmartList Builder or the SQL Table Description???
Verified answer

Mike Smith 6,840 on at

Like (0)

Report

Re: Smartlist Builder: How to create calculated columns based on a User Category Value for certain Inventory Items

If I'm following you correctly, you would have to set-up multiple columns (calculated fields) per analysis.

If you have a User Category = Style with values Long Sleeve and Short Sleeve, you would need Calculated field "UC1Short" and "UC1Long" (any name). Then establish the Case statement for each:

UC1Long:

CASE

WHEN GPUserCategoryField = "Long Sleeve" THEN "Yes"

ELSE "No"

END

UC2Short:

CASE

WHEN GPUserCategoryField = "Short Sleeve" THEN "Yes"

ELSE "No"

END

This would return a data set like:

ITEM UC1Long UC1Short

ShortTShirt No Yes

LongTShirt Yes No