Skip to Content
avatar image
Former Member

#CONTEXT error in a single data source report

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers