Can I perform calculations on specific rows in a data grid?

Absolutely. Using aggregate functions like SUMIF or COUNTIF, you can specify criteria strings (e.g., '[DEPT] = "Sales"') to perform calculations on subset data.

How do I reference a specific control in a formula?

You can reference other controls by using a colon prefix followed by the control name, for example, ':txtPrice' to access the value of a price input field.

Does i-AUD support JavaScript in formulas?

Yes, i-AUD automatically enters JavaScript mode if it detects keywords like 'return', 'var', or curly braces, allowing for complex script-based logic.

What is the i-AUD Formula system?

It is a calculation engine (FormulaManager) within the i-AUD BI platform that allows developers to set formulas on controls like textboxes and grids to automate value calculations.

i-AUD Formula Guide

Name: i-AUD Formula Guide
Author: AUD-DEV-TEAM

byAUD-DEV-TEAM

•

Learning & Documentation

Provides comprehensive syntax guidance and best practices for writing i-AUD calculation formulas across UI controls and data grids.

The i-AUD Formula skill enables Claude to act as an expert consultant for the i-AUD reporting environment, specifically focusing on the FormulaManager system. It provides detailed implementation patterns for automatic calculations in textboxes, labels, and data grids, covering everything from basic arithmetic and control referencing to advanced JavaScript-based logic. This skill is essential for developers building interactive dashboards and reports who need to implement complex data aggregation, conditional formatting, and real-time value updates within the i-AUD framework.

Key Features

01Detailed documentation for aggregate functions like SUMIF, AVERAGEIF, and COUNTIF

02Comprehensive syntax reference for control and global variable referencing

03Grid-specific keyword support for totals, sub-totals, and cell values

04Guidance on switching between standard formula syntax and JavaScript mode

052 GitHub stars

06Extensive library of string, math, and date manipulation functions

Use Cases

01Automating value calculations between multiple UI controls in a reporting dashboard

02Implementing complex conditional logic and data formatting within i-AUD data grids

03Creating custom data aggregations and summary rows using filtered criteria

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add aud-dev-team/i-aud-developer-kit iaud-formula

For use in Claude.ai and ChatGPT

Download Skill