Recent content by LZido

Yeah!! You are the best! Thanks for your help.

It is the one you gave me: if (TONUMBER{Property.LANDINGZONE} >=0 and TONUMBER{Property.LANDINGZONE} <=7500) then 1 else if (TONUMBER {Property.LANDINGZONE} >= 7501 and TONUMBER {Property.LANDINGZONE} <=15000) then 2 else if TONUMBER {Property.LANDINGZONE} >= 15001 then 3

Thanks for the formula. It looks like it will work. It is telling me - The ) is missing - and highlights the {Property.LANDINGZONE} field. I tried putting ) in several places and cannot get it to work.

I have tried that but getting an error "The keyword "then" is missing" if TONUMBER{Property.LANDINGZONE} in "0" to "7500" then 1 else if TONUMBER {Property.LANDINGZONE} in "7501" to "14999" then 2 else if TONUMBER {Property.LANDINGZONE} > "15000" then 3

I have a field that is a string {Property.LANDINGZONE}. The formula below is not returning the correct results. I am assuming I need to convert the string into a number, but not sure how to do this. if {Property.LANDINGZONE} in "0" to "7500" then 1 else if {Property.LANDINGZONE} in "7501" to...

I ended up putting the original formula in the group footer and the formula did work. Thanks for your help and I am going to research the Switch Function. It is great how people are willing to help and respond quickly. THANKS!!

Never heard of a switch function. Sounds interesting! I am getting back "A Boolean is required here" and the last {@WaterSupply} in the formula is highlighted.

I have a formula that scores 3 different criterias: 0 or 1 hydrant (with less than 1000 GPM) = 3 1 at 1000 GPM or over and 1 less than 1000 GPM = 2 1 hydrants at 1000 GPM or over = 1 In my data: {@WaterSupply} is valued at 1293 {@WaterSupply2} is valued at 1435 Formula: if {@WaterSupply} <...

Thank you so much - It works!

I think I am having problems because my data field is a date/time field. I do not have separate fields for date and time. Do I need to adjust the formula because of this?

I am receiving an error: The results of selection formula must be a Boolean.

I am trying to group data by 24 hour time periods. For instance the first time period is from 1/1/2014 8:00:00 to 1/2/2014 7:59:59, the second 1/2/2014 8:00:00 to 1/3/2014 7:59:59, the third 1/3/2014 8:00:00 to 1/4/2014 7:59:59, etc. I could set up groups by a specified order, but that would...

Will do! Good to know about the star. Good to know I can get help!

Thanks - that did the trick.

I need a formula in Column B that will look for duplicate INCIDENTNUMBER from column A and then put them in order based on Response times in Column C. Example: there are three incident numbers "150013" in column A. In column B, I need to see the order based from lowest response time to highest...