I wnat to create a formula that extracts 1 record for a group of data in a drill down so I can create a percent
In the Sample Data below I know if the "code" field data is 789 then that is "Net Sales" and I need value from the "Amount" field:
Example:
Sue 1/1/2003
void code 123 $40.00
cancel code 456 $15.00
net code 789 $300.00
Fred 1/1/2003
void code 123 $80.00
cancel code 456 $35.00
net code 789 $400.00
--------------------------------
Desired Result
Sue 1/1/2003
void code 123 $40.00 13.33%
cancel code 456 $15.00 5.00%
net code 789 $300.00 100.00%
fred 1/1/2003
void code 123 $80.00 20.00%
cancel code 456 $35.00 8.75%
net code 789 $400.00 100.00%
Thanks in advance
In the Sample Data below I know if the "code" field data is 789 then that is "Net Sales" and I need value from the "Amount" field:
Example:
Sue 1/1/2003
void code 123 $40.00
cancel code 456 $15.00
net code 789 $300.00
Fred 1/1/2003
void code 123 $80.00
cancel code 456 $35.00
net code 789 $400.00
--------------------------------
Desired Result
Sue 1/1/2003
void code 123 $40.00 13.33%
cancel code 456 $15.00 5.00%
net code 789 $300.00 100.00%
fred 1/1/2003
void code 123 $80.00 20.00%
cancel code 456 $35.00 8.75%
net code 789 $400.00 100.00%
Thanks in advance