on 01-27-2010 4:53 PM
Hi,
We have an issue with Prompted object , u2018IIFu2019 expression is not taking dimension object in u2018Thenu2019 clause, it takes only the measure object.
Below are the two expressions one with measure and other with dimension, object with measure works fine and dimension doesnu2019t.
Dimension u2013 Prompted trend (Fails with Error)
<EXPRESSION>IIF(@Prompt('Select a time period trend view','A',{'Fiscal_Year','Fiscal_Year_and_Quarter','Fiscal_Year_and_Month','Calendar_Year', 'Calendar_Year_and_Quarter','Calendar_Year_and_Month'},mono,constrained)= Fiscal_Year,@Select(Fiscal Dates\Fiscal Year),A)
</ EXPRESSION >
Measure u2013 Prompted trend (Works fine)
<EXPRESSION>IIF(@Prompt('Select a time period trend view','A',{'Fiscal_Year','Fiscal_Year_and_Quarter','Fiscal_Year_and_Month','Calendar_Year', 'Calendar_Year_and_Quarter','Calendar_Year_and_Month'},mono,constrained)= Fiscal_Year,@Select(Actuals\Actual Amt (Local)),0)
</EXPRESSION>
Has anyone tried to do this in a different way
Thanks,
Anu
Hi,
could anyone find a solution for that??
Thanks!
Joachim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
just to let you know - not overlooked - will look into this.
Ingo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.