Join Our Discussion

Recent site activity

Excel Comparison‎ > ‎

Formula comparison

The following demonstrates enhancements to formula building that make using XpandedReports easier and less error prone.
(Note: Click on images into enlarge)

User Friendly Data Names

The formula creating is "user friendly" because the data names are consistent automatically with the column headings, even if that name has been edited.


Format

Choose the type of format for the result of the calculated column for consistency.




Re-use Formulas


Formulas that have been created for other reports are available for subsequent reports without the need to re-create from scratch. Once the previous formula has been chosen, it is possible to edit as needed.


Additional information

There is additional information and examples provided on the screen, as well as links to additional resources.





Test

Once the formula has been created, click on test to ensure that the calculation is as expected. Enter different data to test multiple scenarios before the computed.


(Click to enlarge)

Sign in  |  Recent Site Activity  |  Terms  |  Report Abuse  |  Print page  |  Powered by Google Sites