Search the Community
Showing results for tags 'month'.
Found 5 results
-
I have two tables Claims and Premium Records on both tables have dates I want to do an analysis for both tables on monthly and yearly basis with a calculation field Analysis (Claims::claims + Premium::premium) my objective is to be able to gather all the records for each month and...
-
I have a customer database and with a customer table and a service call table. I am looking to create a report that would summarize total payment received in each month and a total for any given year with a grand total of every year. Not sure how to set up the layout part for the Year and Month so...
-
Hello, Hope someone can help with this one! I have a simple Prospects list, where I have an 'Expected Date' field (Date), which is set to just show month and year. How would I setup the conditional formatting to set the colour of this 'Expected Date' field according to the 'current month', 'next...
-
We were trying to use Month() calculation to set reminder. However, it is not returning the result as intended. We have a startDate field and would like to add exact 2 months to startDate as reminder. Intended results are: startDate > reminderDate 19/03/2011 > 18/05/2011 01/11/2011 > 31...
-
I have a table where we do our estimates. This table is used by 10 people. The estimates are comprised of estimates made by telephone, by email, and by a physical person entering our office. I have already created calculations and summaries in this table, even with the percentages for each type of e...
