<div>
<div class="content wysiwyg-content">
I have start date of an agreement and their total sale. I’m trying to build a report to show 1st year and show their count. Like if the agreement started in 2012 it is it’s first year and if it is started in 2015 it is its first year. Can some one help me how to write that formula ?? Thank you
</div>
</div>


I have start date of an agreement and their total sale. I’m trying to build a report to show 1st year and show their count. Like if the agreement started in 2012 it is it’s first year and if it is started in 2015 it is its first year. Can some one help me how to write that formula ?? Thank you

Tableau crystal calculation field formula

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

Crystal Reports

Analytics is the discovery and communication of meaningful patterns in data. Especially valuable in areas rich with recorded information, analytics relies on the simultaneous application of statistics, computer programming and operations research to quantify performance. Specifically, areas within analytics include predictive analytics, prescriptive analytics, enterprise decision management, retail analytics, store assortment and stock-keeping unit optimization, marketing optimization and marketing mix modeling, web analytics, sales force sizing and optimization, price and promotion modeling, predictive science, credit risk analysis, and fraud analytics.