Strange Multivalue Error
I have created the following formula in one of my documents:
ROST =[COGS]/[TY].[Snapshot Stock Value]*364
Then used ROST in another formula:
ROST Bucket =If(([ROST] Between(-10000;0)) Or IsNull([ROST]);"5. Dead Styles";If([ROST] Between(0;2);"3. ROST 0-2";If([ROST] Between(2;4);"2. ROST 2-4";If([ROST] Between(8;100000);"1. ROST 8+";"4. ROST 4-8"))))
And Finally created another dimension:
ROST Var =[ROST Bucket] ForEach([Style])
Where, Style = =[L01 Style]+[L01 Style Key] (so that I can identify a unique style)
ROST Var works fine and I get a correct display (See screenshot Correct.png)
Correctly Displayed ROST Var
ROST Buckets are displayed as:
1. ROST 8+
2. ROST 2-4
3. ROST 0-2
4. ROST 4-8
5. Dead Styles
But everytime I open the document again - I get a multivalue error instead (See screenshot Error.png). Which I can solve by changing something in the document - for example: Change the report name, or update table properties. And when I save the document and close and open it again - Multivalue error reappears. Its not a problem if I have the use the document - as I can keep changing minor things. But I need to send this document out - and make it available for Users.
Could you please help?
This looks like a classic case of a dimension becoming a measure. It's some sort of feature (it would be a bug if it had a fix!). Setting it back to being a dimension usually works.