Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / April 2005

Tip: Looking for answers? Try searching our database.

standard math function

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
felix1093 - 28 Apr 2005 17:36 GMT
Probably a dumb question, but I am new in Infopath, I'm trying to anyway
develop a report for my company.
In a field, I am computing the Net Loss after insurance value. The insurance
value is , let's say 100 USD, so, if the Loss is above this value, the
NetLoss = Loss - 100, and if Loss is below 100, NetLoss = Loss.

In total, a good formula is: NetLoss = Loss - max (Loss - 100,0)

How can I compute this in a field, since all math functions appear to only
relate to repetitive fields from tables?

Regards,

FH

KjellSJ - 29 Apr 2005 11:29 GMT
Add an 'Expression box' control for your NetLoss field and the function (fx)
button for the 'XPath' field in the poup dialog. Enter your formula "Loss -
max (Loss - 100)", verify it and click OK twice.

> Probably a dumb question, but I am new in Infopath, I'm trying to anyway
> develop a report for my company.
[quoted text clipped - 11 lines]
> FH
>  
felix1093 - 29 Apr 2005 20:46 GMT
Thanks for your reply.
Unfortunately I did not succeed to implement the max(0,Loss-100) function.
Can you copy/paste the expression with Xpath?

regards,

> Add an 'Expression box' control for your NetLoss field and the function (fx)
> button for the 'XPath' field in the poup dialog. Enter your formula "Loss -
[quoted text clipped - 15 lines]
> > FH
> >  
KjellSJ - 30 Apr 2005 08:48 GMT
You're quite right that you cannot use max() on two separate fields.

As an alternative, use rules on the Value and Loss fields to set the value
if the NetLoss field. You will need to have two rule conditions, one for when
Loss>Value (1), and one for when Value>=Loss (2). Setting the NetLoss will
then be either (1) =Loss-Value or (2) =Loss.

You could also use OnAfterChange scripts on the same fields to do the
calculations.

Note that in both solution your user will have to actually change the
content of one of the fields to trigger the calculation.

KjellSJ (http://kjellsj.blogspot.com)

> Thanks for your reply.
> Unfortunately I did not succeed to implement the max(0,Loss-100) function.
[quoted text clipped - 21 lines]
> > > FH
> > >  

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.