Skip to Content
avatar image
Former Member

Help with variable formula

=If ([Groups].[Seq Id] > [Groupid]) Then [Groups].[Code]

I get "incompatible object [Groupid] at position 25"

[Seq id] and [Groupid] are numbers.

What am I doing wrong?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 30, 2014 at 07:26 PM

    Hi Kyle,

    The error doesn't mean that the type of the object is incompatible.  It means that the objects themselves are incompatible as far as the semantic layer is concerned.  Are these objects from different contexts within the universe?  Does your universe allow multiple SQL statements for each context?

    I notice that you use [Groups].[Seq Id] and [Groups].[Code] but only use [Groupid].  Is there a [Groups].[Groupid] object you can use instead?

    Is [Groupid] a merged dimension or is it from a different query?

    any ways, this error has to do with the semantic layer compatibility of the objects, not the type. 

    Hope that helps you get past it.

    Here are some helpful resources:
    Error messages explained

    Using formulas, calculations, contexts, etc...

    Webi user guide:


    Add comment
    10|10000 characters needed characters exceeded