The problem is the conditional highlighting in a crosstab. There is a simple crosstab with one the column year and the rows displaying commodity natural gas and oil
The table’s got two measures, a value and a limit value. Now I want to create a simple conditional formatting. If the value higher than the limit, make it red, else green.
if {Report.Value} > {Report.Limit}
then red
else
green
The problem is, it always turns red, even if the limit is higher than the value. The formula works in a normal table in the detail section. Obviously the condition compares the sum values of the row for limit and value. I tried the currentfieldvalue function, but this does not help for my comparison.
Somehow it must be possible, in Webi it is very easy to do this.
I am not so experienced with Crystal, more spoiled with Webi.
thanks in advance
Hell AhirBO,
I tried this. However the formula editor in the condition button alert function only allows text strings. Maybe I don not understand your solution:
However t’'ve asked the question in the sap forum and I’ve got an answer which is feasible (with one defective appearance)
f CurrentFieldValue>GridValueAt (CurrentRowindex,CurrentColumnIndex ,CurrentSummaryIndex+1) then crgreen else crred;
The only problem is, I have to place the second field (the value to compare with) as well in the crosstab section. It is suppressed, but it needs some space, even with minimum height.
(BOB member since 2008-02-25)