OBIEE calculations

Question

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 1Header 2Header 3Header 4Column 1Column 2Column 3Column 4AGreenValue 1(Value 2 + Value 3)*100/ (Value 1 + Value 2 + Value 3)ARedValue 2AYellowValue 3

Regards,

Pavan

Gianni Ceresa · Answer

Hi,

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

choracy69 · Answer

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)) )