StockValue
Calculates the stock value by summing a number column filtered to the maximum date
Category: aggregate
Syntax:
StockValue([number_column], [date_column])
Returns: Number
Context Filtering: ✓ Yes
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
number_column |
column\|number |
✓ Yes | The numeric column to sum |
date_column |
column\|datetime |
✓ Yes | The date column to filter by maximum date |
Allowed Column Types for number_column: INT, FLOAT, DECIMAL
Allowed Column Types for date_column: DATETIME, DATE
Validation
- Minimum parameters: 2
- Maximum parameters: 2
Examples
StockValue([Quantity], [StockDate])
Sums quantity for the most recent stock date