Hi, I am new to crystal reports, so please help.
I am trying to create a formula in crystal that will use 2 recordset fields (category and total), and based on the category will return a corresponding total.
There are 5 categories available.
I tried using if statement, as well as select case, but it only returns the value of the first one.
dim amount as number
if category=1 then
elseif category=2 then
ElseIf category=3 Then
ElseIf category=4 Then
ElseIf category=5 Then