Fromula

[Sot]

am using 2 formulas(@Finacial,@Balance)in my report.
In both formula I have inserted same database table field({Visit.pay_id}).

If run the report, i am not getting the database value
where i have insert the second formula(@Balance). only 0 i am getting.

But in the first formula(@Finacial) i am getting the value.

Content Of the Formulas:
@Financial

If IsNull({visit.paid_amt}) then
{visit.paid_id}
else
{visit.paid_amt}

@Balance

{visit.paid_id}


i have included @finacial in detail section
and @Balance in Group footer section.Both in Same report

 

[DanENW]

If null values are possible then you should probably use the same formula, at least in essence, in both cases.

 

[Sot]

In first row i am trying to display paid_id(thru @Financial)--- which is fine
In second row i am trying to display paid_amt(thru @Financial)--which is fine


In third row i am trying to display paid_id(thru @Balance)

this line is confusing me it gives always 0.00

 

[DanENW]

In the group footer section the formula will only be using the last value of {visit.paid_id} selected and sorted for the group. If this value is null you will get either a blank result or a zero result; if this value is non-null you will get that result.

 

[Sot]

Yes u r correct...How do i rectify this issue....

 

[trublumiller]

The easiest way is to sort by {visit.paid_id). Null values first. That way you will have a value in your last record. Kim

 

[DanENW]

What are you trying to accomplish. It looks like you are only trying to pring the most recent value of Pay_ID in the group footer. If so, then trublumiller's solution is perfect. But if you want something else, then please explain what your goal is for the group footer.