Skip to Content
0
Former Member
Jun 10, 2015 at 09:27 AM

Using of variables in web intelligence rich client

133 Views

Hello Everybody,

I have to calculate a ratio as :

=([TOTAL] En ([YEAR];[Name_MONTH])/[FACTURACION MARCH 2014] En ([YEAR];[Name_MONTH) )*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 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)

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

MORE FORMULAS..........

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

and

differents variables for the column RATIO, NOW I CAN INSERT ONLY THE VARIABLE RATIO3

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

THANKS IN ADVANCE.

Attachments

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