Thanks a ton for the help.. I have included a workbook as you have suggested. I'm still getting some odd results..
If you see in the data source I have... TEAM, ESTIMATED and ACTUAL as the column headers...
TEAM - Random Team names
ESTIMATED - Estimated ship
ACTUAL - Actual ship date
If there is a date in ESTIMATED then there will either be a date in Actual or NO DATE.. The NO DATE is what I'm interested in and I want a count per team in the end....
Am I making any sense? First time asking
test book for community.twbx 31.3 KB
Should have mentioned... in the actual field it wouldn't be a "Y" it would just be another date.
I can get it to work in my test workbook but my real data is having an issue.
Notice in the attachment that all NULL and NULL are bringing back the 1 value.
IF ISNULL([Actual]) AND NOT(ISNULL([Estimated])) THEN 1 ELSE 0 END
What about the calculation above? This will eliminate those with nulls in both fields, and return 1 for those with a non-null date in "estimated" and a null date in "actual".
I think we are getting there
How would you combine the below.. They are two separate calculations at the moment and they work great alone.
IF ISNULL([Whq Rfc Tooling Actual]) AND NOT(ISNULL([Whq Tooling Target])) THEN 1
ELSE 0 END
IF ISNULL([Whq Rfc Upper Actual]) AND NOT (ISNULL([Whq Upper Target])) THEN 1
ELSE 0 END
If you want to combine them into one calculation, you could chain them with an ELSEIF like so:
ISNULL([Whq Rfc Tooling Actual]) AND NOT(ISNULL([Whq Tooling Target])) THEN 1
ISNULL([Whq Rfc Upper Actual]) AND NOT (ISNULL([Whq Upper Target])) THEN 1
You are amazing and thanks for the help!
I have a simple calculated field going on that looks like the below:
IF [Whq Tooling Variance]>7 then 1
ELSEIF [Whq Upper Variance]>7 then 1
ELSE 0 END
for some reason still they will not combine into one number.
Hard to say why it's not combining without seeing a workbook. The logic for that specific calculation fine to me, should funnel both types of variances >7 into the category "1", and all else into 0.
So Great... Thanks for all the help..