If negative value display zero

[SciMax]

I've looked all over but couldn't find anything on this requirement I have.

I have a text box control with a data type of Decimal (double) which
contains a simple calculation -- MinStaff - Absenteeism. What I need is to
have the value display "0" if it is a negative.

Is this possible?

 

[S.Y.M. Wong-A-Ton]

You could use the following formula as the Default Value for your result field:

(MinStaff > Absenteeism) * (MinStaff - Absenteeism)

This is a clean solution introduced by Alec Pojidaev back in the SharePoint
forum. View the thread here:
http://social.msdn.microsoft.com/Fo...h/thread/ed826d07-46ad-4db1-b288-19a7e5624d72

 

[SciMax]

Thank you for the information. This formula works perfects (I don't know
why it works perfectly <grin>).

Curiousity question: I searched using the criteria "If negative value
display zero" and a number of other similar combinations but the discussion
you referred to didn't come up. What is there a better way I could have
asked the question so I get all the applicable discussions?

I am evaluating InfoPath as a new iForm design tool, and therefore not
familar with all the jargon, etc. Yet.

 

[S.Y.M. Wong-A-Ton]

That's a difficult question to answer. And I totally understand why it is
difficult for someone who is not familiar with a product to come up with
queries that would bring up good search results.

And to make things worse, the InfoPath newsgroup (here) and the SharePoint
InfoPath Forms Services forum are not tied in any way.

What I generally recommend is going to Google or Bing, and doing a search
there. Or use the "Search this group" button in the upper right corner of the
following page:
http://groups.google.com/group/microsoft.public.infopath/topics?hl=en

And never feel too embarrassed or afraid to ask a question. However, I do
recommend doing a search - as you correctly did - before asking a question,
because many questions have already been answered.

Hope this helps.