Topic: Fromat Corss Tab Field With Condition Posted: 08 Sep 2010 at 11:12pm
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
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum