I have a query that I want to display key figs that will aggregate.
For example:
char -> 0DF_PREQ
char -> 0DF_PREQITM
char -> 0pur_group
char -> pr_rlsdt
char -> zprrlsta
key_fig -> 0netprice
cal_key_fig-> z_mike_test
cal_key_fig -> ckf_mike_test
z_mike_test is defined as:
general calculation: abs(date1 - date2)
aggregation: std
aggregation reference_char: 'none'
calcuate after aggregation - checked
cal_key_fig is defined as:
general calculation: z_mike_test > 40
aggregation: std
aggregation reference_char: 0DF_PREQ
When I run it I get 8 rows. The days are calculating properly, and my counter displays 1 in the ckf_mike_test column for 6 of the 8 records so I'm all happy. 0DF_PREQ is unique for 6 occurrences (i.e. one 0DF_PREQ has 3 0DF_PREQITM)
However, when I take out 0DF_PREQ I get 7 rows and my counter displays 1 in the ckf_mike_test column for 5 rows. What I expected to happen is for one row to have a 2 in it, i.e. there should have been an aggregation still by 0DF_PREQ.
What am I doing wrong?
Mike