I get "Multiple Value" in a cell of a column of a cross table using Rich Client

[former_member283957]

Hi Tanveer,

Let me show you another issue.

I have to calculate the ratio with BILLING VALUES now for the "fiscal year"  not the natural year.

I mean from march 2014 till february 2015.

The report using natural year 2014 is working but the second report using fiscal year 2014 is not working , I get MULTIPLE VALUE

The variable is the same for both reports.

[RATIO_SUMA]

= (Suma([Importe MSTAR]+[Importe LITE]+[Importe RESTO]) En ([AÑO])/([TOTAL FACTURADO])*100 )

[RATIO_SUMA]

= (Suma([Importe MSTAR]+[Importe LITE]+[Importe RESTO]) En ([AÑO])/([TOTAL FACTURADO])*100 )

Thanks in advance.

Best Regards.

[amitrathi239 · Accepted solution]

Hi,

use the sum function in the varlor multiple_1 image you have attached.if this will not work drag individual object/variable in the report and first see if everything is showing values or not.

Amit

[former_member283957 · Accepted solution]

Hi,

I am already using the sum  function -> Suma()  in a context ->En [AÑO] , In [YEAR]

I am selecting 2014 and 2015 FISCAL YEAR 2014:

from march 2014 till february 2015.

[RATIO_SUMA]

= (Suma([Importe MSTAR]+[Importe LITE]+[Importe RESTO]) En ([AÑO])/([TOTAL FACTURADO])*100 )

Please rewrite it below more clear.

"if this will not work drag individual object/variable in the report and first see if everything is showing values or not."

[amitrathi239 · Accepted solution]

Hi,

= (Suma([Importe MSTAR]+[Importe LITE]+[Importe RESTO]) En ([AÑO])/([TOTAL FACTURADO])*100 )

In the above formula you have used multiple objects/variables.Drag individual one in the report and see in which variable you are getting error.

Then check the formula of that variable.

Amit

[former_member283957 · Accepted solution]

Hi,

I am getting ERROR in this part of the RATIO:

Suma([Importe MSTAR]+[Importe LITE]+[Importe RESTO]) En ([AÑO]

I think is because of this context -> In [YEAR] = En ([AÑO])

When I select the natural year 2014 it works but now I am selecting two years 2014 and 2015

from march 2014 till february 2015 and this part in BOLD of the RATIO:

= (Suma([Importe MSTAR]+[Importe LITE]+[Importe RESTO]) En ([AÑO])/([TOTAL FACTURADO])*100 )

get MULTIPLE VALUES -> Suma([Importe MSTAR]+[Importe LITE]+[Importe RESTO]) En ([AÑO]

How to change the context In [YEAR] ?

[amitrathi239 · Accepted solution]

= (Suma([Importe MSTAR]+[Importe LITE]+[Importe RESTO]) En ([AÑO])

In above formula all are the objects coming from webi query or you have created variables.

If some are variable then  again drag and see values are coming or not?

If all working then use In [YEAR]  context for each one object/variable you have used..

Break this formula in mulitple columns and see where is the issue.

Amit

[former_member283957 · Accepted solution]

Dear Everyone,

Finally I solved the issue.

I attach an screenshot.

Regards.

Antonio