I hope someone out there has experience with this. I am trying to use a cell calculation in my cube that formats a value based on the account it is using (Percent or Currency). The following cell calculation I wrote as a script in my calculation. However when I reprocess the cube the value just disappears. Am I missing something? Thank you for your help.
CREATE CELL CALCULATION [Property].[TestFormat]
FOR '([Income_Statement].[Account List].&, [Budget Variance])'
,FORMAT_STRING = "#,##0.00 %;-#,##0.00 %";