Skip to Content
0
Former Member
Jun 10, 2015 at 02:10 PM

# Using of variables and input controls in web intelligence rich client

218 Views

Hello Everybody,

I have to calculate a ratio as :

=([TOTAL] En ([YEAR];[Name_MONTH])/[FACTURACION MARCH 2014] )*100

[TOTAL] IS THE VALUE OF THE COLUMN Cant.Reclamada which shown the TOTAL receipts per month and year

[FACTURACION MARCH 2014] IS A VARIABLE WHICH GET THE VALUE FROM AN INPUT CONTROL OF TYPE INPUT FIELD where I can input the TOTAL billing per month and year.

This formula :

=([TOTAL] En ([YEAR];[Name_MONTH])/[FACTURACION MARCH 2014] En ([YEAR];[Name_MONTH) )*100

Should be dynamic changing the variable [FACTURACION MARCH 2014] for EACH month,

Example FORMULA RATIO FOR MARCH 2014

=([TOTAL] En ([YEAR];[Name_MONTH])/[FACTURACION MARCH 2014] En ([YEAR];[Name_MONTH) )*100 should

Example FORMULA RATIO FOR APRIL 2014

=([TOTAL] En ([YEAR];[Name_MONTH])/[FACTURACION APRIL 2014] En ([YEAR];[Name_MONTH) )*100 should

THIS FORMULA RATIO is WRITTEN in the RATIO3 VARIABLE which is inserted in the column RATIO

HOW CAN I SOLVE THIS TROUBLE ?:

HOW CAN I INSERT DIFFERENTS FORMULAS FOR EACH MONTH IN THE COLUMN FACTURACION (Billing) of the CROSS TABLE

=Si (Year([Day Contabilizacion]) =2014) Y (Month([Day Contabilizacion])="marzo" ) Then [FACTURACION MARZO 2014] Else ""

...........................

=Si (Year([Day Contabilizacion]) =2014) Y (Month([Day Contabilizacion])="abril" ) Then [FACTURACION ABRIL 2014] Else ""

and

HOW CAN I INSERT differents variables IN the column RATIO of the CROSS TABLE. ?

NOW I CAN INSERT ONLY THE VARIABLE RATIO3 ,

Can I INSERT DIFFERENTS VARIABLES IN DIFFERENTS CELLS OF THE SAME COLUMN OF THE CROSS TABLE ?

RATIO3 = ([TOTAL] En ([YEAR];[Name_MONTH])/[FACTURACION MARCH 2014] )*100

NEW VARIABLE FOR APRIL 2014

RATIO4 = ([TOTAL] En ([YEAR];[Name_MONTH])/[FACTURACION APRIL 2014] )*100 ???

THANKS IN ADVANCE.

Attachments

VARIABLE RATIO3.jpg (362.4 kB)
RATIO COLUMN.jpg (353.6 kB)