Answer

Problem with the formula field in the Crystal Report

Nel

12y

1.2k

Hello,

I have two formula fields in the report footer in my Crystal Report.
The both values should depend on the value of another field. Fo r example if {DataTable3.vid}="Pri" it should take the value of Iznos from the table for the rows where vid is "Pri" and if vid ="Isp" it should tkae the value of Iznos for that rows of the datatable where vid = "Isp"

Here is my formula for the first formula field, which works fine:
if({DataTable3.vid}="Pri") then Sum ({DataTable3.Iznos}, {DataTable3.vid})

and the value for the second formula field, which doesn't function ok:
if({DataTable3.vid}="Isp") then Sum ({DataTable3.Iznos}, {DataTable3.vid})

The second returns 0.00

Can anybody help me please?
Thanks in advance