Multivalue error

building reports webintelligence
1

Hi All,

I am using below formula, it’s working fine in Deski report. But it’s giving error in webi report. :hb:

=Max([Query 1 with HR3].[Effective Salary Change Date]) Where([Salary Year]=2007)

can u pls help me ASAP.

Thanks,
Praveen

praveen557 (BOB member since 2008-05-07)

2

Whats the SLA on this then? Why the big urgency?

anyway, try something like…

=Max([my_object])Where ([Year]="1888")

Do I get a cookie?

dessa :madagascar: (BOB member since 2004-01-29)

3

Or

Max(If([Salary Year]=2007;[Query 1 with HR3].[Effective Salary Change Date]))

Give Dessa his cookie, mines a banana… :rotf:

Mak 1 :uk: (BOB member since 2005-01-06)

4

Thanks a lot Mark !!!

your idea is workin!!!1, take a cookie!!!1

praveen557 (BOB member since 2008-05-07)

5

Hi Mark,

I applied same formula in another column, just i changed the year, it’s given #FORMAT ERROR

CAN U HELP ME

thanks,

praveen557 (BOB member since 2008-05-07)

6

I got it Mark,

Now My idea working

praveen557 (BOB member since 2008-05-07)

7

… points to the Edit button … thanks :slight_smile:

Dave Rathbun :us: (BOB member since 2002-06-06)

8

Hi Mark,

why it’s working in Deski and it’s not work in webi.

Can u give me clarification ?

Thank,
Praveen.

praveen557 (BOB member since 2008-05-07)

9

Yup, calculation engines are different, in terms of the syntax required…

Mak 1 :uk: (BOB member since 2005-01-06)