Search results for query: *

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...

I have a formula that states if {@FLSA D11}is greater than the total of {@OtherOT} then minus {@OT D11} and receiving an error - "A formula cannot refer to itself, either directly or indirectly" Problem Formula FLSA D11 if {@FLSA D12} <= 0 then Sum ({@ODC Hours D11}...

I have a formula that will not work in the Report Header but will work in Details. I created a formula to add a day to a parameter date {?Start Date}+1. I did this for 7 days. I then wrote a formula to give me the total hours based on type of hours for each day. First formula: This is based on...

I am trying to create a report where all the personnel's data (date, type of hours, total hours) are on one row in order to export to excel. The problem is there are multiple dates for one person. Each date has a corresponding type of hour and total hours. My data consist of; Personnel...

That worked! Thanks for the help.

I am trying to get a grand total for all groups. I have groups with totals for items and totals for cost. I multiple the total items by their cost. ITEM (each of these are groups) QNTY (this is a group summary) COST (@TotalCost) Adult Cric Kit...