2 Replies Latest reply on Oct 18, 2019 11:53 AM by Steelbird

    how to Implement this: column formula = GROSS SALES/SUM(GROSS SALES BY SEGMENT,PERIOD)

    Steelbird

      Guys how to implement this:

       

      column formula = GROSS SALES/SUM(GROSS SALES BY SEGMENT,PERIOD)

       

      Gross sales  - Invoice amount

       

      Segement: CASE WHEN "Inventory Organization"."Inventory Org Code" = 'KAD' THEN ' H & H' WHEN "Inventory Organization"."Inventory Org Code" in ('BAN','USA') THEN 'Bty' END

       

      Period: Fiscal Period.

       

      How can we implement above formula in obiee report column.