asked on

Customer reward points calculation

Hi experts,

I have asked this question earlier but haven't got any reply. Could someone reply.

I have customer reward points data. I have 2 tables.

1. CumulativeCredit -> Customer credited points and cumulative total
2. CumulativeDebit -> Customer debited points and cumulative total

From these 2 tables, I need to generate resultset to show how the customer points are debited. I mean the points debited are to be distributed as per they earned.

See attached spreadsheet for sample data and expected resultset.

I am totally mad to solve this.

Could someone have an eye on this and suggest how to achieve the result?

thanks
Points.xlsx

ASKER CERTIFIED SOLUTION

Jim Horn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Ryan McCauley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rajvja

ASKER

Hi ryanmccauley,

Thanks for the reply. I dont want monthly breakdown.

Yes the requirement is nasty. I want to split the debit points based on credit date.
For example, if I have used 500 points today that means definitely i should have earned those points earlier. But they might have earned on different dates.

My requirement is to split 500 pts when they have earned.

I hope it is clear.

rajvja

ASKER

Thanks for the replies. It hasn't resolved my issue.

rajvja

ASKER

I've requested that this question be closed as follows:

Accepted answer: 0 points for rajvja's comment #a38382526
Assisted answer: 250 points for jimhorn's comment #a38375934
Assisted answer: 250 points for ryanmccauley's comment #a38377444

for the following reason:

Not resolved my issue