• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

FRM

ABOULAZHAR

New Member
Hello all,
Please i have a problem to found the result of the FRM methods in excel (a sampling of 3000 client, it was no possible to do the excercise manually) :
find the RFM for each client:

5 for the recence, de 3 for the fréquency et de 2 for the amount :

- R : 20 if the latest purchase was in december 2018 ; 18 if the latest purchase was in november ; 16 if the latest purchase was in october, 14 if the latest purchase was in september, 12 if the latest purchase was in august, 10 if the latest purchase was in july, 8 if the latest purchase was in june, 6 if the latest purchase was in may, 4 if the latest purchase was in april, 3 if the latest purchase was in march, 2 if the latest purchase was in february, 1 if the latest purchase was in january, 0 if no purchase in 2018.

- F : multipling 3 with the number of transactions during 2018 with a maximum of 40.

- M : 10% of the total amount of purchases during 2018, with a maximum of 60

Please i need some excel fonction to work with, and how to implement those fonctions in the DATABASE

Best regards,
 

Attachments

Top