Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Math Calculation in Bex query

Dear Experts,

I have the below data in BW.

Date Time(Hr)

CO2

(zk_value)

H2O

(zk_value)

20/2/201410.6659396.141796
20/2/201420.5845073.286
20/2/201430.6021693.636601
20/2/201440.6666843.030161
20/2/201450.6949913.515662
20/2/201460.7155073.424114
20/2/201470.7400893.739442
20/2/201480.6467522.978481
20/2/201490.5497142.152406
20/2/2014100.498012.804975
20/2/2014110.4310978.513797
20/2/2014120.41158850.08882
20/2/2014130.237801110.5091
20/2/2014140.21837896.62129
20/2/2014150.24238146.51961
20/2/2014160.24030419.21492
20/2/2014170.3262984.918987
20/2/2014180.3899334.256416
20/2/2014190.4041483.939687
20/2/2014200.4103643.430606
20/2/2014210.4166533.10039
20/2/2014220.448333.06806
20/2/2014230.4813012.99557
20/2/2014240.55795912.70483

Now i need to represent the data in BI report as below.

Prarmeter          Max(in a day)     Min(in a day)   Daily Avg

CO_mgm          0.74                    0.21               0.48

H2O                  110.5                  2.15             16.85

Used Parameter and Date  as Characteristic info object (rows)

created 3 formulas in columns. In general tab of formula i selected (zk_value * 1) and in aggregation tab i  selected as max , min, avg in exception aggregation and used date as ref characteristic for all the 3 formula respectively but im not getting correct values. Im simply getting summation as the result.

Please guide me to achieve the result.

Thankyou

Vijay

Tags:
Former Member
replied

Hi Vasu,

Can you try doing this below.

In the calculations tab of formulas for max value use " Calculate result as Maximum" similarly for minimum value use " Calculate result as Minimum" .For average use "Calculate result as average"

I guess this will help.

Thanks,

Dharma

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question