Hi All,
I have a report having qty fields.I need to show as zero when value is null.
So wrote a formula like this.
@Target Qty:
if is null(qty) and is null(act qty) then 0 else qty * act qty.
I placed this is in detail section and working fine.
Then I created a summary sum(@Target Qty) for this.This also should show as zero when the qty fields are null.
I placed this in report footer .Whenever i kept this in report the @Target Qty which is in detail section is hiding.If i removed summary formula then @Target Qty is showing.
Please suggest what is the problem
Hi Divya,
So if I understand this correctly, you have a formula (@Target QTY) placed in the Details Section.
You've then inserted a summary on the formula and placed it on the Report Footer. After the summary is paced on the Report Footer, the formula field on the Details Section disappears?
Do you have a conditional suppression logic for the field or the section? Are you sure this is what is happening?
-Abhilash
Add a comment