Search results for query: *

This is my delema; I have a report of premiums sorted by month in decending order and I added a Group number to diplay next to the month field. I created formula fields and everything looks great. Now my boss asked me to add a target field and then subtract the target field to an existing...

Thank you, It worked. You are a genius..... Renata

Thank you, I told them to turn it up side down and they said that would work. Ha Ha..... Accually, I just copied them to the Report header. Thanks for your reply. Renata

Hello, I need help on adding a Grand total minus the last 3 months of premium. I have it Grouped on a date field and have a Grand total already but now they want another Grand total minus the last 3 month. Would someone help me please. Date field {effdate} Grouped by month decending and...

Hello, I need help on creating a grand total of annual premium minus 3 months from current month. This is called a 3 month off set number. Does anybody know how to create this formula? Thank you very much for being there for me. Renata

I am working on a report where the Grand totals need to be moved to the top of the page. Can this be done? I have formulas in the detail section which is hidden and summaries below displayed. Please let me know if this is something that can be done. Thank you very much. Renata

I have 2 databases with one field alike. I want to link with that one field called "Duration". It is exact and I would like to link on it. How do I do this? Thanks Renata

Below is a formula field I'm using and I need to only diplay it when numbers are in the field. Is ISNULL the answer and How would I put it in this formula? select {Clmincr.DURATION} case 1: "2001" case 2: "2000" case 3: "1999" case 4: "1998" case 5...

I have a report sorted under product, age and effective year. I have the data almost the way I want it but need to combine years 89 and 90 and display it under 90. Any suggests? Should I use a formala. I did try one formula I created but it didn't work. Here it is: if{@efft year} =1989 and...

select Year(CurrentDate)-{Clmincr.CIISSYEAR} case <=1 &quot;Duration 1&quot; case = 2: &quot;Duration 2&quot; case = 3: &quot;Duration 3&quot; case = 4: &quot;Duration 4&quot; case = 5: &quot;Duration 5&quot; case = 6: &quot;Duration 6&quot; case = 7: &quot;Duration 7&quot; case = 8...

I have another question on a formula selecting dates and if it equal a year to put text in it. I'm trying to create duration of a claims policy. This is not working. Can someone help me? select Year(CurrentDate)-{Clmincr.CIISSYEAR} case <=1: &quot;Duration 1&quot; case = 2: &quot;Duration...

I'm using CR7 on foxpro 2.5 dbf and trying to copy this formula and change month = 2. the formula below works for month = 1 but doesn't work for any other months. (data exist in other months) All formulas are in the Detail section. Report is grouped by year field. Please help. This one...

No it didn't work. I still get 00's instead of amounts in database. Any other suggestions?

I'm using CR7 on foxpro 2.5 dbf and trying to copy this formula and change month = 2. the formula below works for month = 1 but doesn't work for any other months. (data exist in other months) All formulas are in the Detail section. if (tonumber({Clmanal.MONTH})=1 and (((ToNumber...