Quantum Ideas Portal
Welcome to the FIS Treasury and Risk Manager - Quantum Edition Aha! Ideas Portal.
By visiting this portal, you will be able to contribute towards the evolution of the Quantum solution through interactions with other Quantum users, FIS trusted partners and FIS staff from around the world. Each Portal User receives 5 votes. Each user is allowed 1 vote per idea. Votes are reset when an idea is in a final state i.e. Shipped (delivered in the product).
Users will receive weekly email updates that highlight new activity. Users will receive emails for their created ideas when:
Status changes
Comment changes
Be aware that when you post content, other community members will see your name. FIS is not responsible for content posted by other Aha! Ideas Portal Users.
Expression builder - New and Changed Functions
The following is a new function used in Expression Builder. This new function takes data from cash explorer worksheets, using the last data version from each date for the worksheet parameters provided.
CashForecast
Description
Returns cash forecast amount for specified date and grouping from relevant CashXplorer data version.
Format
CashForecast(query, view, rowGroups, optional forecastDate, optional firstHorizonStartDate)
Arguments
query - CashXplorer query name
view - CashXplorer forecast view name
rowGroups - list of text values for each row group
forecastDate - date to return forecast for
firstHorizonStartDate - date to identify data version with
Example 1
CashForecast( "12 Months", "Forecast", { "EUR", "Surplus / Deficit" }, 18-Jul-2018 )
The result is 23,330,362.
Returns the value of the Jul bucket, assuming data version 1 on 23-May-2018 is the latest before today.
Example 2
CashForecast( "12 Months", "Forecast", { "EUR", "Surplus / Deficit" }, 14-Jun-2018, 24-May-2018 )
The result is 20,705,934.
Returns the value of the Starting 11-Jun-18 bucket, assuming data version 1 on 23-May-2018 is the latest before 24-May-2018.
Example
CashForecast()