Help with variable formula

[Former Member]

=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?

[former_member59613]

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

http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp4_error_messages_en.pdf

Using formulas, calculations, contexts, etc...

http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp5_ffc_user_guide_en.pdf

Webi user guide:

http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp5_webi_user_guide_en.pdf

Jb

[Former Member]

I created a context in my universe that joins the two tables but it still is not working.