asOf()

returns the result of a carrot expression on a particular date using either only primary data, or both primary and scenario based data syntax asof returns the result of a carrot expression on a particular date using data from both primary, and the scenario that the function is used in asof( date date, expression {cql} ) date the selected date expression the carrot (cql) expression return type the data type result of the carrot (cql) expression code sample result asof('2017 07 01', {performancerating}) returns the value of performancerating as of january 7th, 2022 using data on primary and from proposed scenario changes asofprimary returns the result of a carrot expression on a particular date using data from primary asofprimary( date date, expression {cql} ) date the selected date expression the carrot (cql) expression return type the data type result of the carrot (cql) expression code sample result asofprimary('2017 07 01', '2022 08 01", 2 5) returns the value of performancerating as of january 7th, 2022, using only the data on primary does not include data from proposed scenario changes