-
1. Re: Converting Measure to Dimension
Hi Kristen,
Could you provide more information, such as your calculation formula or a screenshot of the issue?
-
2. Re: Converting Measure to Dimension
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
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
It is not allowing me to create a combined field when doing that – any other suggestions?
-
5. Re: Converting Measure to Dimension
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?