If one works, the other dont.

[Vegaanders]

Hi All!



I have two problems left on my pay slip report that I think is connected.

One field on the report is expenses. If this field is empty the label is hidden. That how it should work.

I also have a field that calculates the net paid out salary.

The code looks like this

([Salary_Euro]+[Expences_Euro])-[Admin_Fee_Euro]

Now, if the expense field is Null, nothing shows up, if the expense field is set to default 0, then all is OK. The problem is that the expense field now shows all the time, which of course is normal because the value is not Null.

Can the code for the expense field somehow be changed to also ignore the 0

Code is here

 =IIf(IsNull([Expences_Euro]),"","Expenses:")

[ranman256]

prevent nulls by converting fields to zero with:

=NZ([Salary_Euro])+nz([Expences_Euro])-nz([Admin_Fee_Euro])

[Vegaanders]

Solved it!
Thank you