Mathematical functions in Formula

[Former Member]

Dear all,

I have problem in defining formula to find Minimum and Maximum values on particular Key Figures. The Key Figures are defined in Cell Definition. In Calculated Key Figures, there are some Mathematical Functions are provided, but no documentation are available. What is the Minimum of 0 and operand or Minimum functions are for?

Thanks for the help.

Regards,

Ricky

[Former Member]

Ricky,

When I right mouse click on a key figure (not within the Cell Editor) and select Properties, there is a Calculate Results As option - Minimum and Maximum are available here.

More info on the mathematical operators can be found on:

http://help.sap.com/saphelp_nw04/helpdata/en/71/0aec3b6e011341e10000000a114084/content.htm

Regards

Gill

[Former Member]

Hi Gill,

I went to the link that you gave me, unfortunately, the Mathematical Operators are not explained there. I have no idea why SAP does not put the explanation of Mathematical functions there, since I found them a little bit confusing.

Thanks,

Ricky

[Former Member]

hai

check this for Mathematical Functions

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb32d5358411d1829f0000e829fbfe/content.htm

regards

abi ram

[Former Member]

Hi Ricky ,

If you want disply Min or max value particular keyfigure that you will get info object level under Aggregation tab .

Plz assign points if it is useful.

Thanks,

Vijay Sekahr Reddy.