How to Calculate “Total” for the number of days as its given incorrect results;
IF( ISBLANK([Date of Last Purchase]) || VALUE([Date Selected] - [Date of Last Purchase]) <= 0, BLANK(), VALUE([Date Selected] - [Date of Last Purchase]) )
As usual, looking forward for your help and support.
I’ve had a quick review of the tutorial and struggling to understand what the total of all these days actually offers.
I think the reason I didn’t worry to much about the total is because I felt it was meaningless in this instance.
What insight does the total actually offer to you here…Just summing up days on a per customer basis doesn’t really mean much don’t you think?