Has Data Expression

[tafnuef1]

Ok, I have two fields
Field 1 is in a subreport (Document Count Summary subreport) and it is called TotDocCount" and if it "HasData" then I want to Divide Field 2 that is called "Tot Prep Err" by Field 1 on the main report to create a percentage rate. If there is no data to divide I want the field to show Zero..

So on my main report (Prepper Audit Summary Report) I created a text box and put this as the source code. Did I miss something?
=IIf(Document Count Summary subreport].[Report].[HasData], ([Tot Prep Err]/[Document Count Summary subreport].Report![TotDocCount]), 0)

 

[tafnuef1]

Never mind I got it to work with this: =IIf([Document Count Summary subreport].[Report].[HasData]=True,[Tot Prep Err]/[Document Count Summary subreport].[Report]![TotDocCount],0)

Yay!