May 17, 2018 at 6:59 pm #9768
I’ve been using PP for 2 weeks now.
I’ve loaded Excel data and created a pivot table.
When a use a filter everything is fine. But when I try removing it I get this error.
Any Idea where I went wrong ?
ThanksMay 18, 2018 at 12:30 am #9774
It has happened to me before that when clearing (removing) a filter, the greater dataset introduced a division by zero.
Instead of using the division operator (“/”), try using the DIVIDE() function, which handles division by zero without raising an error.
Let me know if that made a difference.
Also, if you could run the text of your message through google translate, that could help also. Otherwise I can just understand the part that reads like there was a syntax error.May 30, 2018 at 12:49 pm #9954
I tried your method but no success.
Here my translation of the error:
Syntax is incorrect.. All the rest of the error is in English.
“Affaires” is the filter I’m using.
Don’t know if that helps !
ThanksMay 30, 2018 at 4:22 pm #9960
The list of measures in the original images do not show a measure where Affaires (?Business) is used.
Is it used in a slicer or part of a formula?June 1, 2018 at 12:11 pm #9979
Here is my list of measures. Hopefully it will help!
ThanksJune 1, 2018 at 7:46 pm #9983
What I do not know is how you are using Affaires, whether in a slicer or if you are working with cube formulas.
Can you put up some sample data in a workbook?
Some of your field names are missing a table prefix, such as [Transfer eligible]. Since this appears to happen consistently with [Transfer eligible], my reaction is that you are referencing a measure, but since it is not listed separately as its own calculation in your list of measures, it must be a column. However, the point here I want to make is sometimes when a table reference is not used with a column in a formula an error can be generated.June 22, 2018 at 1:00 pm #10073
I tried adding table prefix as you can see in image attached.
I’m using some formulas in columns and then using thoses new columns in my measures. I don’t know if that can be part of the problem?June 22, 2018 at 2:48 pm #10075
Not enough information in images alone.
If you do not have time to create a workbook with demo data, at least one other option is to contact our paid help desk. Yes, there will be a charge but you will have an answer without sending a workbook to a public forum.
TomJune 26, 2018 at 12:40 pm #10085
Apparently the problem was in the name of the columns.
Ligne d’affaires was problematic because of the ” ‘ “. Renamed it ligne_affaires and works out fine.
ThanksJune 26, 2018 at 2:59 pm #10087
Pleased to read of your success!
You must be logged in to reply to this topic.