Global Variable in Cross Tab

[bidra]

CR 8.5 / 10

Hello,

I've got a problem receiving the correct value from a global variable in a cross tab formula.

The cross tab is defined in report header.
The global variable are to prevent double countings under certain conditions.
The code for the formula goes like this:

--------------------------
WhileReadingRecords
Global MultNum as number
Global MultKey as number

formula = 0

If MultNum <> {TAB1.ATNUM} Then
MultNum = {TAB1.ATNUM}
MultKey = 0
End If

If ({TAB1.LP} = 1621 Then
MultKey = MultKey + 1
End If

If ({TAB1.LP} = 1621
if MultKey < 2 then
formula = + 1
end if
else
formula = + 1
end if
--------------------------

The formula results show that global variable are not set and changed properly, eg. 2 instead of 1 .

Did I use the global variable not correctly or is there missing something else ?

Many thanx in advance

bidra