1 Reply Latest reply on Oct 4, 2018 4:44 AM by meenu choudhary

    Summing the last 3 "active sales date"


      Hi all,


      I have a data source whereby the sales do not necessary occur everyday. But then I will need a calculated field whereby it will sum the 3 latest 3 "active sales date", and find an average.



      I.e. If the latest sales I made was on 1st Sep, 27th Aug, 15th Aug, then Iwant to sum these 3 dates sales figures.




      Want a table like this with "last 3 days sales" = 12