Adding a formula to a widgetIf you want to display more specific information on your widgets, you can create your own column by defining a formula for it. You can often write the formula you need by entering simple mathematical equations. However, to enter more complicated formulas, you must either understand how to use Microsoft SQL commands or request the services of an Ajera consultant (to learn more about Microsoft SQL, search the Microsoft website). Video: Table widgets: formulas and formatting (4:38) Before you beginTo add a formula to a widget
The Formula Builder opens. Types of formulas that can be created
[Total Contract Amount] - ([Billed] + [WIP])
Example: § Formula A = [Billed] * 1.5 § Formula B = [Formula A] / [Hours worked] |
Concepts About designing Ajera dashboards Tasks Setting up dashboard Designer access Changing Column Properties on Chart Widgets Designing Purchase Order Task Widgets Filtering information in a widget Setting conditional formatting Setting a date range in a widget Assigning roles and employees to tabs Exporting a chart widget to PDF Exporting a table widget to PDF Exporting a table widget to Excel Copy a widget to a new page or tab Adding a Gantt chart to a table widget Editing Gantt Column Properties Changing the scale of a Gantt chart References |
© 2023 Deltek Inc. All rights reserved. |