Hi
i want to get an Expression (as in table), which is given by
sum({$<ControlGroup ={'nein'}>} Sales)/count({$<$(vSet),ControlGroup ={'nein'}>} contact_ID)
-
sum({$<ControlGroup ={'ja'}>} Sales)/count({$<$(vSet),ControlGroup ={'ja'}>}contact_ID)
i want to narrow the expression on a purchase_date field interval for every action, whose limits are the fields [From - To] dates. This is, Campaign A consists of Actions {A1,...., A9}, which were carried out based on the dates "From - To". The value of the expression shall adjust to the purchase_date selected.
I tried this formula, but i do not get the desired result:
sum({$<purchase_date = {">=$(From)<=$(To)"}, ControlGroup ={'nein'}>} Sales)/count({$<$(vSet),ControlGroup ={'nein'}>} contact_ID)
-
sum({$<purchase_date = {">=$(From)<=$(To)"},ControlGroup ={'ja'}>} Sales)/count({$<$(vSet),ControlGroup ={'ja'}>}contact_ID)
do you have any suggestions on this?
thanks
Felipe
Table summary:
Campaign | Action | From | To | Expression |
A | A1 | 08.06.2013 | 30.06.2013 | 9.57 € |
A | A2 | 28.05.2013 | 15.06.2013 | 5.25 € |
A | A3 | 29.05.2013 | 15.06.2013 | -0.97 € |
A | A4 | 29.05.2013 | 15.06.2013 | -2.40 € |
A | A5 | 31.05.2013 | 15.06.2013 | 8.64 € |
A | A6 | 31.05.2013 | 15.06.2013 | 4.46 € |
A | A7 | 31.05.2013 | 15.06.2013 | 10.32 € |
A | A8 | 31.05.2013 | 16.06.2013 | 6.04 € |
A | A9 | 31.05.2013 | 16.06.2013 | 8.03 € |
Total | | | -0.98 € |