Skip to Content
avatar image
Former Member

how to get max value from sales dimension/measure using script in sap design studio

how to get max value from salesRevenue measure(column) using script in sap design studio.

And assign that value on charts_1 Y-Axis dynamically on runtime.

I am using efashion DB..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Nov 24, 2016 at 06:23 PM

    Hi Safal,

    The easiest way to get maximum value dynamically is, in your initial view of data source use calculate total as option as maximum as shown below

    Then you can use below code to get result row data

    DS_1.getDataAsString("Measure", {});


    Thanks,

    Poovarasan

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Safal,

      For your requirement you can create a copy of same measure in initial view of data source by adding a dynamic calculation. Then you can calculate maximum and minimum in two measures.

      So you will get both minimum and maximum values from data itself. No need of scripting.

      Thanks,

      Poovarasan

  • avatar image
    Former Member
    Nov 26, 2016 at 08:46 PM

    Thanks bro....

    For your Help..It is really helpful for me..

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 06, 2016 at 05:58 PM

    Hi Poovarasan

    I am having a similar issue to min and max value from measure in textbox and calculate them to find avg..

    How to get these values using foreach loop and array..

    As the previous idea fails in that condition...


    Add comment
    10|10000 characters needed characters exceeded

  • Mar 14 at 09:40 AM

    Hi,

    Were you able to solve this issue ?

    If yes then let me know the process for the same.

    Thanks in advance.

    Regards,

    AL

    Add comment
    10|10000 characters needed characters exceeded