Skip to Content
0

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

Nov 24, 2016 at 12:54 PM

413

avatar image

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..

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Best Answer
Poovarasan Boopalan Nov 24, 2016 at 06:23 PM
0

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


initial-view.png (16.4 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

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..

Is it possible to achieve this values using foreach loop and array and compare dynamically

As the previous idea fails in that condition...

0

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

1
SAFAL AGRAWAL Nov 26, 2016 at 08:46 PM
0

Thanks bro....

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

Share
10 |10000 characters needed characters left characters exceeded
SAFAL AGRAWAL Dec 06, 2016 at 05:58 PM
0

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...


Share
10 |10000 characters needed characters left characters exceeded