FRM

[ABOULAZHAR]

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,

 

[vletm]

ABOULAZHAR
Would You reread Forum Rules: https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/
and
after that do needed actions as there has written.

PS. For me, FRM means Fault Report Manual.​