I am trying to create a calculated field than has all entries where the "Lead_Time" is less than 0.
I did this in two different ways, the first way was the following.
Right-clicked on the "Dimensions" list to pull up the menu that appears and clicked "Create Calculated Field..."
Typed "Lead Less Than 0" in the "Name:" textbox in order to name the calculated field
In the "Parameters:" column I clicked "Create..."
Typed "Cal_LT_0" to name my parameter
In "Allowable Values" I chose the "Range" radio button
Clicked "Set from Field" and then "Lead_Time" from the list that appeared
I left the lowest minimum value that was automatically generated but changed "Maximum" to -1
Pressed "OK" and then double clicked on my newly created parameter "Cal_LT_0"
Just to check to see what was generated, I put the newly created "Lead Less Than 0" dimension in the "Rows"
It generated -5973 entries, the total amount of entries I have * -1
I did the exact same then as step one in "First Way"
Named it something different, lets just say "Test 2"
I typed the following: IIF([Lead Time] < 0, [Lead Time], 0)
I figured this was just a statement that tested to see if an entry's Lead_Time was less than 0 it would add it to the new "Test 2" calculation. If not, it would "0" or false meaning it wouldn't do anything with that entry
This way generated -5,255 entries when it should've generated