repeng_error_en_71 wis 00071 while creating conditional format rule

[Former Member]

Hi

I am facing  repeng_error_en_71 wis 00071 when creating conditional format rule in webi

I am creating rule using formula editor

e.g Formula: if [Obj]=[Obj] then [Obj] and it throws an error.

however it works when I simply write if 1=1 then 1

Is there anything wrong with Object comparison?

Thanks,

Amit

[Former Member]

Again as I believe comparing same object or 2 objects directly using equal to operation never worked in BO.

And when using normal selection(without formula) options to compare two objects or similar objects.

In background it might be doing n*n comparisons or something like that, not sure though.

Any insights are highly appreciated.

[Former Member]

Hello,

I have a similar issue and I followed the online help example:

If <Main Condition> is true, Apply <Main Format>

ElseIf <Second Condition> is true,  Apply <Second Format>

ElseIf <Third Condition> is true,  Apply <Third Format>

ElseIf...

Else Apply <Default Format>

I could add my formular to compare a condition like [value1]*1,05 >[value2] is true, Apply <Main Format>

Else Apply <Default Format>

The editor tells me, my formula is correct, but I receive same error message.

What is expected for <Main Format>?

Thanks,

Monika

[Former Member]

Hi Amit,

Conditional formatting does not have any formula bar to write If/Else condition. Can you provide screen-shot of what exactly you are doing? Also screenshot of error would be helpful.

[Former Member]

Hardik,

I tried to use functions rather than traditional drop down options.

[Former Member]

Amit,

For the formula to work the formula must return True or False. True triggers the condition; False does not.

I think your formula is not returning boolean value TURE/FALSE thats why you see this error..

[former_member189638]

Buy may I know what exactly you want in the report?  Because the condition Obj = Obj is always going to be true.

[Former Member]

but comparing same object should return true right. As when I am doing same with just traditional conditions without formula it is working fine,

So anything wrong with formula editor.

or

My way of comparing object is incorrect

[Former Member]

Hey Rakesh even thats what my belief is about Obj=Obj.

I was trying few things with alerters where condtions provide very restricted scope. So I went to Formula editor to try my luck and there it was every time when I treid the same thing.

However it works fine with normal comparison without formula editor.

So was wondering if anything wrong with my way of comparison.