Skip to Content
author's profile photo
Former Member

how to write macros in BEx to multifly two columns

Hi,

We have an issue in Bex report. we need to go for macro coding..

could you please help me out,how to multifly two columns...

example here it goes..

Calendar Year/Week Tank size CA CB CA*CB(use macro)

31.2007 39 10H 480 H 10H*480H

32.2007 39 2 0 H 672 H 20H*672H

I will appreciate your help in this..

Thanks in Adavnce!!

SS

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Oct 11, 2007 at 03:44 PM

    Hi,

    If it is simple multiplication of two keyfigures , then you can create calculated keyfigure Or Formula.

    Regards

    SSS

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for the Prompt response..

      Here we canot go with cal keyfig or formula as we had differnt key fig properties..

      key fig 1 --> Aggregation type "sum"

      key fig 2 --> Aggregation type " max"..

      Thanks,

      Ss