DESIGNER CALCULATED MEASURE FOR REVENUE BY DOCUMENT TYPE

building semantic layer
1

Hello friends. I am trying to calculate the custom measure that calculate the revenue where document type = KA

can u please help me with the code that can be used in oracle data base to implement using the revenue measure and document type object to have revenue by document type = KA

tHANKS

SONIYA

soniyakaren (BOB member since 2009-07-21)

2

Here you go

 CASE WHEN TNAME.document_type = 'KA' THEN TNAME.REVENUE ELSE 0 END

.

haider :es: (BOB member since 2005-07-18)

3

Hi,

If it’s a measure then I would wrap the above formula with SUM() function:

SUM (CASE WHEN TNAME.document_type = 'KA' THEN TNAME.REVENUE ELSE 0 END )

Marek Chladny :slovakia: (BOB member since 2003-11-27)