Jump to content

Calculating negative values


This topic is 6508 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I need to create a summary field for work oustanding containing the total of a certain field, however, some of the values in this field have a negative value due to the way my client works...

example

record 1 work oustanding on project x = -10

record 2 work oustanding on project y = 45

At present the calculation = 39 when in actual fact the work oustanding is still 45

What i need to achieve is a calculation which ignores the negative values or at the very least treats them as ZERO so that negative values do not impact on the work still oustanding in the summary field.

Version: v6.x

Platform: Windows XP

Link to comment
Share on other sites

Hello cabalamedia,

Summary fields don't provide a lot of controls and options, so if you want to alter their behavior you need to be a bit 'lateral' in approach.

What I suggest that you do is to define a calculation field with the formula:

Max(0, YourField)

- and then re-define the summary field for work outstanding, to provide the total of the calc field. The calc field need not appear on any layouts - it can operate entirely behind the scenes, but it will have the effect of 'filtering out' any negative values from the data being totaled by your summary field. cool.gif

Link to comment
Share on other sites

This topic is 6508 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.