Avatar of Erin Leale
Erin Leale
Flag for United States of America

asked on 

SSRS "If - then - else" formula #error

I'm new to SSRS - using - Report Builder 3 with Epicor.  I have a formula that should prevent a divide by 0 error.  

=iif(Fields!Calculated_Inv_Margin.Value = 0, 0,

It does the percent calc great - but anything with a 0 gets an #Error.  So I took out the divide calc and just had the revenue field show - that works.  Why doesn't the the calc above just give me a 0?

Any help would be great!  Thank you! 
SSRSMicrosoft Server OSMicrosoft SQL Server

Avatar of undefined
Last Comment
Erin Leale

8/22/2022 - Mon