-
1. Re: Converting Measure to Dimension
jiayi zhang Jul 25, 2016 11:55 AM (in response to Kristen McDonough)Hi Kristen,
Could you provide more information, such as your calculation formula or a screenshot of the issue?
-
2. Re: Converting Measure to Dimension
Kristen McDonough Jul 25, 2016 11:59 AM (in response to jiayi zhang)Thank you for the prompt response!
This is the calculated field:
IF ="Regular Quant" AND ="Regular Qual"
THEN "Regular Fruit"
ELSEIF ="Regular Quant" AND ="Premier Qual"
THEN "Premier Fruit"
ELSEIF ="Regular Quant" AND =”Gold Qual"
THEN "Gold Fruit"
END
-
3. Re: Converting Measure to Dimension
jiayi zhang Jul 25, 2016 12:21 PM (in response to Kristen McDonough)The calculation seems correct to me. Maybe you can try to create a combined field instead.
Control click the two calculations and then right click and choose "Create-Combined Field". Hope it works
-
4. Re: Converting Measure to Dimension
Kristen McDonough Jul 25, 2016 12:36 PM (in response to jiayi zhang)It is not allowing me to create a combined field when doing that – any other suggestions?
-
5. Re: Converting Measure to Dimension
Andrew Watson Jul 25, 2016 12:51 PM (in response to Kristen McDonough)Does your formula work? If what field = "regular quant" and what field = "regular qual"? Something doesn't look quite right, generally you would need to specify the fields on which you want the calculation to apply.
IF [Field1] ="Regular Quant" AND [Field2] ="Regular Qual"
THEN "Regular Fruit"
...
END
Also what happens when [Field1] doesn't equal regular quant? What do you want to happen?