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!