Hi all,

i have a cross tab that show data about some work process .
and i have in the columns filed [Date-time] field name [WorkingDay] grouped by month to show the values in cells collected by month

and in the row i put a field called branch to view whats happen in every branch by month

and in summarized fields i put 2 fields
Quantity Sold and Quantity Remaining

and i want to highlight on of the Quantity Remaining if its Value is Greater than
the Quantity Sold

to show there's a wrong sale process in this branch this month,

so ... i had used highlighting expert but it takes values not formulas
and try to use this formula but it doesn't work ...


if sum({CRPGetCapacityAllCross;1.ActiveQty},GroupName ({CRPGetCapacityAllCross;1.WorkingDay}, "Monthly"))>
sum({CRPGetCapacityAllCross;1.RemainingQTY},GroupName ({CRPGetCapacityAllCross;1.WorkingDay}, "Monthly"))then crred


any idea

thanks ...






Edited by samehsenosi - 08 Sep 2010 at 11:13pm