OBIEE calculations

user8591891

Hello All,

I have the below requirement we need to calculate Column 4, similarly we have to calculate for other values of column 1 (B, C, D) too

Please help me with the inputs, Thanks!

Header 1	Header 2	Header 3	Header 4
Column 1	Column 2	Column 3	Column 4
A	Green	Value 1	(Value 2 + Value 3)*100/ (Value 1 + Value 2 + Value 3)
A	Red	Value 2
A	Yellow	Value 3

Regards,

Pavan

choracy69

Hi,

I think that you should use FILTER in your formule.

For example:

If you want show value on first row you can add something like that:CASE WHEN Column 2 = Green THEN .... END

Next you create formule, maybe something like that:

( FILTER(COLUMN 2 USING (COLUMN 2 = RED)) + FILTER(COLUMN 2 USING (COLUMN 2 = YELLOW)) ) * 100 / ( FILTER(COLUMN 2 USING (COLUMN 2 = GREEN)) + FILTER(COLUMN 2 USING (COLUMN 2 = RED)) + FILTER(COLUMN 2 USING (COLUMN 2 = YELLO)) )

Gianni Ceresa

Hi,

It will of course depend on how your model looks like but you can also play on hierarchies levels etc.