How use the custom formula feature to pass a formula or function to an Excel or Google spreadsheet when exporting data out of AZInsight?
Follow the steps outlined below for instructions on how to pass a formula or function to a spreadsheet when exporting out of AZInsight:
1. Click on the gear settings icon then click on Export Configuration
2. Locate the Export profile you wish to use under the "Manage Export profiles" table and click edit
3. Drag and drop the "Custom Formula" or click on the checkbox next to Custom Formula and move the field to the right hand to active it
4. Click on the pencil next to the work Custom Formula to open the formula or function editor window
5. Enter a name for your formula or function
6. Enter the formula or function referencing the column letters to perform a function
For example, you can specify a function to add the data in cell A with the data in cell B by using =sum(A:A+B:B)
Click here to see an example list of formulas/functions that you can pass to an excel and google sheet.
6. Click on Save to apply the change
7. Go into the calculator screen and click the G button to export the data and then view your spreadsheet with your formula.
Related Articles
Examples that you can use on the custom formula feature when exporting data out of AZInsight
Below are some examples of formulas or functions that you can use What to use =SUM(range) What it does it will add the values of a cell to another cell Example =SUM(A:A+B:B+C:C) How it can be used You can use the sum to add for example two custom ...What data can I export out of AZInsight?
AZInsight can export data out of both the calculator screen and the variations viewer screen to Quick Copy, Export to CSV (excel), and to the Google Sheets Integrations Data you can export from the Calculator Data you can export from the Variations ...Can I have a custom data field in the 1st column when exporting to Google Sheets
Since version 2.8.0, the Google Sheet Integration name has been changed to Export Configuration. On AZInsight version 3.0.2, we changed the Export Configuration screen. You can read more about this on our Google Sheet Integration support article. ...I exported to Google Sheets but it doesn't show up on the last row on the sheet
The Google Sheets mechanism that AZInsight communicates with will automatically send the data directly to the last row (also known as bottom up) on the Google sheet. But formulas or actions present on the sheet may manipulate the data causing the ...How does the Custom Export Fields feature work?
Since version 2.8.0, the Google Sheet Integration name has been changed to Export Configuration. On AZInsight version 3.0.2, we changed the Export Configuration screen. You can read more about this on our Google Sheet Integration support article. ...