Search
Search

# 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/2014 1 0.665939 6.141796 20/2/2014 2 0.584507 3.286 20/2/2014 3 0.602169 3.636601 20/2/2014 4 0.666684 3.030161 20/2/2014 5 0.694991 3.515662 20/2/2014 6 0.715507 3.424114 20/2/2014 7 0.740089 3.739442 20/2/2014 8 0.646752 2.978481 20/2/2014 9 0.549714 2.152406 20/2/2014 10 0.49801 2.804975 20/2/2014 11 0.431097 8.513797 20/2/2014 12 0.411588 50.08882 20/2/2014 13 0.237801 110.5091 20/2/2014 14 0.218378 96.62129 20/2/2014 15 0.242381 46.51961 20/2/2014 16 0.240304 19.21492 20/2/2014 17 0.326298 4.918987 20/2/2014 18 0.389933 4.256416 20/2/2014 19 0.404148 3.939687 20/2/2014 20 0.410364 3.430606 20/2/2014 21 0.416653 3.10039 20/2/2014 22 0.44833 3.06806 20/2/2014 23 0.481301 2.99557 20/2/2014 24 0.557959 12.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

##### dharmateja nandipatireplied

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
View more on this topic or