on 01-20-2015 11:42 AM
Hi Experts,
=Sum([Non Auto].[CY MTD Val] Where([Non Auto].[Industry Code 2]InList("General Industrial";"High Performance Ctg";"Powder Coating") And MonthNumberOfYear(ToDate(FormatDate(ToDate([Non Auto].[Customer].[Customer - Cust Intro Date (Key)];"dd.MM.yyyy");"MM.yyyy");"MM.yyyy"))>=MonthNumberOfYear(ToDate("4"+"/"+"1"+"/"+FormatNumber(Year(ToDate(UserResponse([Non Auto];"Enter Month Year");"MM.yyyy"));"#");"MM/dd/yyyy")) And Year(ToDate([Non Auto].[Customer].[Customer - Cust Intro Date (Key)];"dd.MM.yyyy"))=Year(ToDate("4"+"/"+"1"+"/"+FormatNumber(Year(ToDate(UserResponse([Non Auto];"Enter Month Year");"MM.yyyy"));"#");"MM/dd/yyyy"))) ForAll([Non Auto].[Customer].[Customer - Key]))/100
This Formula showing #Error when used in Cell but when i used with corresponding field in blank table its shows the value....
please help urgently.
Thanks
Ashwini
When I have issues like that I start with a table in which I put in all the dimensions used as a basis for the formula and
build it up in separated cells, till I have the formula. This is done to view construction errors and build it up correctly.
Once that is done , I duplicate the report and remove the dimensions one by one till I have the reporting scope that I need, this allows for detecting reporting context issues.
Working in a cell can give you issues because you always are working in a global reporting context.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.