evend
asked on
Crystal Crosstab Carry Over Previous Column Value If Current is Null?
I have crosstab that shows columns based on period ending dates where the values come from a table. I used the maximum option to pull the last record for a given period end date. Which is usually the last day of the week. However, some weeks that are no records for a given customer so I want the crosstab to carry over the value from the previous end date.
This is used for monitoring ending inventory values from week to week and some weeks a customer may not have an inventory record so we need to carry over the previous weeks value.
This is used for monitoring ending inventory values from week to week and some weeks a customer may not have an inventory record so we need to carry over the previous weeks value.
Record selection:
{named_periods.name} = "Weeks" and
{Vend_Visits.visit_DateTime} = {?Date} and
{points_of_sale.pos_active} = "Y" and
{Vend_Visits.financial_status} <> "V"
group formula:
{Vend_Visits.visit_DateTime}=maximum({Vend_Visits.visit_DateTime}, {periods.name})
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I may try something like that, Thanks!