Skip to Content

#CONTEXT error in a single data source report

Apr 25, 2017 at 02:01 PM


avatar image
Former Member

Hello All,

I'm trying to create a report that reviews our top 30 customers. In the report, everything stems from a single universe. I was able to create the ranking variable, and then I created a dimension that has a "grouping" through use of an If formula:

[Group]=If([Rank]<31; "Top 30"; "")

From this grouping, I want to make a report with a break that shows our top 30 customers, and then a single row below that has "all other customers", essentially. I tried to create another column that says:

If([Group]="Top 30";[Customer];"Other Customer")

This last equation gives me a #CONTEXT error. Both the [Group] and [Customer] dimensions are strings. The [Customer] variable comes direct from the data source, and [Group] is a created variable. Checking other posts, it seems most other errors stem from combined datasources not having appropriate columns / merged dimension or combining fields with a different data type (strings and Numbers, for example). Any thoughts what this might be?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers