5 Replies Latest reply on Oct 26, 2018 1:33 PM by Deepak Rai

    Using a calculated field in a formula

    Himanshu Patil

      I need to calculate Revenue per Unit from the first half of 2017 (Jan through June) and multiply it with the number of Visits in 2018. Workbook attached for reference

      So basically sum(first-six-month-2017-Revenue) / sum(first-six-month-2017-units) * visits (2018).

      How do I write the formula? Would appreciate any help.