4 Replies Latest reply: Oct 14, 2015 1:12 PM by Evgeniy Dobrutskiy RSS

    How to compare current 7 days that have values with previous 7 days and receive % growth or number.

      I need script grab last 7 days which have values, found average for transaction in this period (for this purpose I'm using - Sum(points)/Count(distinct cash_table_id & '|' & salescript_group_name)    )   than take previous 7 days, make the same calculations and return the difference in percents or some numbers.

       

      Thank you!