Introduction:

Datarails offers an integrated function in Excel that allows users to build custom reports. This guide walks you through the process of creating these functions, ensuring you leverage the full potential of Datarails within Excel.
To read more about Datarails formulas and Datarails functions, please refer to this article.

Unlock the secrets of Datarails! Dive into our Online University and transform your learning journey today!

Key Takeaways:

1. Datarails in Excel can auto-update based on the latest uploaded data.
2. The platform offers flexibility, letting users adjust formatting, reference cells, and utilize features like drill-downs and dynamic ranges.

Setting Up:

1. Before accessing certain Datarails functionalities in Excel, you need to save the file.
2. For beginners, it's advisable to use the formula builder to introduce functions into Excel.

Creating a Datarails Function:

Using the Formula Builder:

1. Click on the formula builder to open its interface.
2. Select your desired function and define parameters in columns and rows.
3. If uncertain about which function to use, consult your customer success manager or Datarails champion.
4. For our example, choose the value function to get values from the GL data.
5. Decide which data you want, like revenue over a specific period, and add the necessary parameters.
6. Use the formula builder to copy the DR get function or view the formula to copy from there.

Making the Function Dynamic:

1. The Datarails Function acts like a query. The DR GET function can be compared to Excel's SUM IFs function.
2. Parameters set criteria ranges and criteria.
3. To make the function dynamic, utilize Excel's referencing capabilities.

Adding Additional Categories:

1. Starting with the basic DR GET function, add parameters one-by-one using Excel's formula bar.
2. Right-click and select the Datarails option, followed by “Parameters”.
3. Choose the field selector box to add desired criteria.
4. Advanced users can manually add criteria by typing directly into the formula.

Using Aggregations:

1. Besides the DR GET, Datarails offers aggregations like year-to-date or quarter-to-date.
2. To apply, replace DR GET with the desired aggregation type.

Troubleshooting:

1. If you see a value error in your Excel after inserting the function, activate the function in Datarails.
2. "Missing" cells indicate the need for a data refresh. Refresh data in Datarails as required.
3. Naming conventions are essential. Ensure you're using the correct terminology to avoid errors.

Conclusion:

Datarails provides users with a robust function in Excel that can customize data extraction with multiple aggregations. With its user-friendly interface and flexible configurations, it simplifies data analysis tasks and optimizes reporting.

For further assistance or queries, we're here to help! Join us in our next training session to delve deeper into Datarails' capabilities.

Updated November 13, 2023 10:08