RFM-R DATEDIFF('day',{ FIXED [Customer ID]:MAX([Invoice Date])},{MAX([Invoice Date])}) RFM-F ({ FIXED [Customer ID]:COUNTD([Invoice ID])}) RFM-M {FIXED [Customer ID]: SUM([Sales Amount])}
RFM-R DATEDIFF('day',{ FIXED [Customer ID]:MAX([Invoice Date])},{MAX([Invoice Date])}) RFM-F ({ FIXED [Customer ID]:COUNTD([Invoice ID])}) RFM-M {FIXED [Customer ID]: SUM([Sales Amount])}