Hey Doug,
Sounds like you need an outer join query. However, are your tables normalized with a foreign key reference for lookups?
There has to be some sort of connection between the two Parent to Child so you can form an outer join query without getting into the mess of a Union query which...
The reason ehaze is asking about field types is that MS Access does NOT like multi-value fields from external datasources for example if one of your fields in SP is an attachments type field, it does not translate well or come across unless you modify the way Access can handle the field...
One other thing, in 2010 Rank is handled in to different way, one is Ran.EQ which works in the same wasy as RANK(). Assigning each value or rank a different ranking even if two scores are the same. What you may be looking for is Rank.AVG() which assigns rank for tied values. So iff two things...
Is this the result you are seeing?
16.70 9.40 26.10 1
15.40 9.60 25.00 5
16.10 9.80 25.90 3
16.10 9.90 26.00 2
16.20 9.70 25.90 4
16.60 10.00 26.60 1
15.90 9.70 25.60 4
15.70 10.30 26.00 3
15.60 9.70 25.30 5
16.40 10.20 26.60 2
What is it that you are trying to clarify? Are you...
Skip and Andy, I solved it thanks to both of your inputs:
An old instructor once told me to "talk the formula through through out loud"....I am such a dunce.
Here is the fix because the Current Equipment Count defaults to ZERO, the value is Zero and should be represnted as 0 (ZERO) and don't...
PROBLEM SOLVED. An old instructor once told me to talk the formula through through out loud....I am such a dunce.
Here is the fix because the Current Equipment Cound defaults to ZERO, the value is Zero and should be represnted as 0 (ZERO) and don't do a calculation if none of your friends are...
Andy,
Thanks! However the #DIV/0 error still shows: SharePoint List View 2007. Both fields are numbers so we are not mixing apples with oranges.
Here is my syntax:
=IF([Current Equipment Count]="",0,(IF(OR([Unit Strength]="",[Current Equipment Count]=""),0,ROUNDUP([Unit Strength]/[Current...
Skip,
I am still getting the DIV/0! error. SP accepts the syntax but I have two records that have Unit Strength ( number of people) that is greater than 0 (ths is true in all cases) but they may not have any items on hand. I recognize that we are trying to mask the divisor if no value is true...
I will try your suggested change. It makes sense, however in the db there may be occasions where one or the other is blank (no value) or both may have values in the event of a contract renewal.
I formed the above query in that way because of the situation in another calc column on subtracting...
All,
This should be very simple, but to be frank I am drawing a brain blank. I have two fields and I am trying to get a ratio. For the most part it works but if there is no value in Current Equipment, I get the famous #DIV/0! error that the command staff find a bit on the annoying side...
All, I have a fairly straight foward issue. MS SharePoint 2007, view with calculated columns.
I have a calculated column that has the following forumla
=IF(OR([Field]=””,[field2]=””),0,ROUNDUP([field1]/[field2],0))
ISSUE: If Column 2 does not have a value then the dreaded #DIV/0! error shows...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.