CustomImageTag
The CustomImageTag class is applied to PowerPoint Report Templates when
the following text is found in a text box:
${customImage:imageName} where imageName is the name of the image
used in the tool. The text box will be removed and replaced with the image,
and all animations present on the text box will be applied to the image as
well.
Note: this tag is used to get the users uploaded image from the Generate Report Modal.
Optional parameters include fit, scalex, and scaley. fit will generate an image that will fit inside the container and fill either the height or width of the container depending on the image's scale ratio. scalex will generate an image as wide as the container with a proportional height, and scaley will generate an image as tall as the container with a proportional width. If both scalex and scaley are included, only scalex will be applied.
Both the tag and parameters are case-insensitive.
See ReportTag for syntax.
Examples:
${customImage:logo,scalex}${customImage:logo,scaley}${customImage:logo,fit}
DuplicateSlidesTag
The DuplicateSlidesTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${duplicate:benefits,numslides=2}, ${duplicate:vmcs},
${duplicate:sections}, or ${duplicate:investments}
where the slides will be duplicated for each benefit, value map category, or
investment.
numslides determines how many slides will be duplicated for each
benefit, value map category, or investment starting with the current slide.
Optional parameter numslides is the number of slides to copy. Default is 1.
Optional parameter filter can be used with benefits or Value map categories. Can filter by value passed in, either Monetary or Non_Monetary.
Optional parameter top or bottom can be used with benefits to list results by impact value. Takes a number for maximum results returned.
When benefit slides are duplicated, and text that contains [benefitid] will be replaced with the concrete benefit id, so tags can be nested. For example, a tag like this
${nr:DBB[benefitid]_Overview_Name} Page 1 in a slide that is
duplicated, will be replaced with
${nr:DBB1234_Overview_Name} Page 1, which will then be processed
by the
nrtag.
When value map slides are duplicated, text that contains [vmcid] will be replaced with the concrete value map category id.
When investment slides are duplicated, text that contains [investmentid] will be replaced with the concrete investment id.
The tag is case-insensitive.
See ReportTag for syntax.
Examples:
${duplicate:vmcs}- Duplicates one slide for each value map category.${duplicate:sections}- Duplicates one slide for each section.${duplicate:benefits,numslides=2}- Duplicates 2 slides for each benefit.${duplicate:benefits, numslides=2, filter=monetary, top=3}- Duplicates 2 slide for the top 3 benefits that is monetary.${duplicate:investments}- Duplicates one slide for each investment.${duplicate:vmcs, filter=Non_monetary}- Duplicates one slide for each value map that is non monetary.
HighChartTag
The HighChartTag class is applied to PowerPoint Report Templates when
the following text is found in a text box:
${chart:chart_name} where chart_name is the id of the chart
used in the tool. The text box will be removed and replaced with the chart
image, and all animations present on the text box will be applied to the
image as well.
Optional parameters include fit, scalex, and scaley. fit will generate an image that will fit inside the container and fill either the height or width of the container depending on the chart's scale ratio. scalex will generate an image as wide as the container with a proportional height, and scaley will generate an image as tall as the container with a proportional width. If both scalex and scaley are included, only scalex will be applied
.Both the tag and parameters are case-insensitive.
See ReportTag for syntax.
Examples:
${chart:roi_chart,scalex}${chart:roi_chart,scaley}${chart:roi_chart,fit}
TableTag
The TableTag class is applied to PowerPoint Report Templates when the
following text is found in a text box:
${table:table_name} where table_name is the id of the table
used in the tool. The text box will be removed and replaced with the table,
and all animations present on the text box will be applied to the table as
well. The table will fit the width of the container the tag is placed in.
Optional parameters include scaleY which, when used in conjunction with
Optional parameter split will duplicate slides and create new tables if it does not fit on a single slide.
Optional parameter copyHeader, will share the table header on new tables created during a split.
Optional parameter headerFg will set the foreground color of the table header to the entered Hex value.
Optional parameter headerBg will set the background color of the table header to the entered Hex value.
Optional parameter textForeGround will set the foreground color of the table rows to the entered Hex value.
Optional parameter textBackground will set the background color of the table rows to the entered Hex value.
Optional parameter subTotalFg will set the foreground color of the table subtotal rows to the entered Hex value.
Optional parameter subTotalBg will set the background color of the table subtotal rows to the entered Hex value.
Optional parameter totalFg will set the foreground color of the table total rows to the entered Hex value.
Optional parameter totalBg will set the background color of the table total rows to the entered Hex value.
Optional parameter fontSize will set the font size of all cells to the entered value.
Optional parameter fontScale will scale all fonts by the entered value.
Optional parameter minimumRowHeight will set the minimum row height.
Optional parameter cellMarginLeft will set the cell left margin.
Optional parameter cellMarginRight will set the cell right margin.
Optional parameter cellMarginTop will set the cell top margin.
Optional parameter cellMarginBottom will set the cell bottom margin.
The tag is case-insensitive.
See ReportTag for syntax.
Examples:
${table:multi-year-benefits__table__benefits-by-year, fontSize=8.5}${table:investment__table__annual-investment-by-category,scaley,split,fontScale=1}${table:investment__table__annual-investment-by-category, headerFg=#E0E0E0, headerBg=#11a6c0, textForeground=#FF0000, textBackground=#00FF00}
CurrentDateTag
* The CurrentDateTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${date:current_date} where current_date returns the current date
that the report is generated. The text will be replaced in-line (as opposed to
removing and replacing the container).
Optional parameter fmt that accepts a date format pattern. defaults to "MMMM dd\, yyyy". Note commas must be escaped.
See ReportTag for syntax.
Examples:
${date:current_date}${date:current_date, fmt=MM dd\, yy}${date:current_date, fmt=yyyy-MM-dd}
ItemTableIdTag
The ItemTableIdTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${itemTable:id} where id returns the item table id. This
typically can be used nested in a ${table} tag or other ${itemTable} tags.
Required parameter mnemonic the mnemonic of the item table.
See ReportTag for syntax.
Examples:
${itemTable:id,mnemonic=myMnemonic}
ItemTableNameTag
* The ItemTableNameTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${itemTable:name} where name returns the label name of the item table.
parameter id the id number of the item table.
parameter mnemonic the mnemonic of the item table.
Only one parameter is required for the tag, while the other can be omitted.
See ReportTag for syntax.
Examples:
${itemTable:name, mnemonic=itemTable1}${itemTable:name, id=7}
ItemTableVisibilityTag
* The ItemTableVisibilityTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${itemTable:visibility} where visibility returns true or
false if the item table was visible in the application.
parameter id the id number of the item table.
parameter mnemonic the mnemonic of the item table.
Only one parameter is required for the tag, while the other can be omitted.
See ReportTag for syntax.
Examples:
${itemTable:visibility, mnemonic=itemTable1}${itemTable:visibility, id=7}
LeadCaptureFieldValueTag
The LeadCaptureFieldValueTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${lead:field_value} where field_value returns the value of the
field
required parameter field_name the field_name for the requested field value.
See ReportTag for syntax.
Examples:
${lead:field_value, field_name=FirstName}${lead:field_value, field_name=utm_campaign}
SectionIdTag
The SectionIdTag class is applied to PowerPoint Report Templates
when the following text is found in a text box: ${section:id}
Tag is an alias, see
ItemTableIdTag for
more information.
See ReportTag for syntax.
Examples:
${section:id,mnemonic=myMnemonic}
SectionNameTag
The SectionNameTag class is applied to PowerPoint Report Templates
when the following text is found in a text box: ${section:name}
Tag is an alias, see
ItemTableNameTag for
more information.
See ReportTag for syntax.
Examples:
${section:name, mnemonic=section1}${section:name, id=7}
SectionVisibilityTag
The SectionVisibilityTag class is applied to PowerPoint Report
Templates when the following text is found in a text box: ${section:visibility}
Tag is an alias, see
ItemTableVisibilityTag for
more information.
See ReportTag for syntax.
Examples:
${section:visibility, mnemonic=section1}${section:visibility, id=7}
ShowAltTextIf
The ShowAltTextIf class is applied to PowerPoint Report Templates
when the following text is found in the alternate text of a shape:
${showAltTextIf:{tag value}, eq={comparison value}} where {tag
value} can be an existing tag whose value will be evaluated to the
{comparison value}.
The results of which, if evaluated as true will show the content in the
presentation.
parameter eq test if the {tag value} is equal to this attribute
parameter neq test if the {tag value} is not equal to this attribute
Only one parameter is required for the tag, while the other can be omitted.
See ReportTag for syntax.
Examples:
${showAltTextIf:${tickbox:checked, mnemonic=tickbox1}, eq=true}${showAltTextIf:${calc:industry}, neq=Aerospace & Defense}
ShowColumnIf
The ShowColumnIf class is applied to PowerPoint Report Templates when
the following text is found in a table cell:
${showColumnIf:{tag value}, eq={comparison value}} where {tag
value} can be an existing tag whose value will be evaluated to the
{comparison value}.
The results of which, if evaluated as true will show the column in the table.
parameter eq test if the {tag value} is equal to this attribute
parameter neq test if the {tag value} is not equal to this attribute
Only one parameter is required for the tag, while the other can be omitted.
See ReportTag for syntax.
Examples:
${showColumnIf:${tickbox:checked, mnemonic=tickbox1}, eq=true}${showColumnIf:${calc:industry}, neq=Aerospace & Defense}
ShowRowIf
The ShowRowIf class is applied to PowerPoint Report Templates when
the following text is found in a table cell:
${showRowIf:{tag value}, eq={comparison value}} where {tag
value} can be an existing tag whose value will be evaluated to the
{comparison value}.
The results of which, if evaluated as true will show the row in the table.
parameter eq test if the {tag value} is equal to this attribute
parameter neq test if the {tag value} is not equal to this attribute
Only one parameter is required for the tag, while the other can be omitted.
See ReportTag for syntax.
Examples:
${showRowIf:${tickbox:checked, mnemonic=tickbox1}, eq=true}${showRowIf:${calc:industry}, neq=Aerospace & Defense}
ShowSlideIfTag
The ShowSlideIfTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${showSlideIf:{tag value}, eq={comparison value}} where {tag
value} can be an existing tag whose value will be evaluated to the
{comparison value}.
The results of which, if evaluated as true will show the current slide.
parameter eq test if the {tag value} is equal to this attribute
parameter neq test if the {tag value} is not equal to this attribute
Only one parameter is required for the tag, while the other can be omitted.
See ReportTag for syntax.
Examples:
${showSlideIf:${tickbox:checked, mnemonic=tickbox1}, eq=true}${showSlideIf:${calc:industry}, neq=Aerospace & Defense}
CurrencyIsoCodeTag
The CurrencyIsoCodeTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${currency:iso} where it will return the currency iso code that was
selected. The text will be replaced in-line (as opposed to removing and
replacing the container).
See ReportTag for syntax.
Examples:
${currency:iso}
CurrencyNameTag
The CurrencyNameTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${currency:name} where it will return the currency name that was
selected. The text will be replaced in-line (as opposed to removing and
replacing the container).
See ReportTag for syntax.
Examples:
${currency:name}
TemplateNameTag
* The TemplateNameTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${template:name} where it will return the template name that was used
to create the analysis. The text will be replaced in-line (as opposed to removing and
replacing the container).
See ReportTag for syntax.
Examples:
${template:name}
AnalysisPeriodTag
* The AnalysisPeriodTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${calc:analysis_period} where analysis_period returns current analysis
period in years. The text will be replaced in-line (as opposed to removing and
replacing the container).
See ReportTag for syntax.
Examples:
${calc:analysis_period}
AnnualGrowthRateTag
The AnnualGrowthRateTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${calc:annual_growth_rate} where annual_growth_rate returns the
current annual growth rate percentage. The text will be replaced in-line (as
opposed to removing and replacing the container).
See ReportTag for syntax.
Examples:
${calc:annual_growth_rate}
AvgAnnualBenefitsTag
* The AvgAnnualBenefitsTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${calc:avg_ann_benefits} where avg_ann_benefits returns the
average cumulative benefits over the analysis period based on the projection.
The text will be replaced in-line (as opposed to removing and replacing the
container).
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${calc:avg_ann_benefits}${calc:avg_ann_benefits, projection=Probable, scale=0.001, unit=k, dec=2}${calc:avg_ann_benefits, raw}
BenefitCurrentSumTotalOverPeriodTag
The BenefitCurrentSumTotalOverPeriodTag class is applied to
PowerPoint Report Templates when the following text is found in a text box:
${calc:benefit_current_sum_over_period} where
benefit_current_sum_over_period returns the total sum of all monetary
benefits current values including recurrence over analysis period. The text
will be replaced in-line (as opposed to removing and replacing the
container).
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${calc:benefit_current_sum_over_period}${calc:benefit_current_sum_over_period, projection=Probable, scale=0.001, unit=k, dec=2}${calc:benefit_current_sum_over_period, raw}
BenefitCurrentSumTotalTag
The BenefitCurrentSumTotalTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${calc:benefit_current_sum} where benefit_current_sum returns
the total sum of all monetary benefits current values. The text will be
replaced in-line (as opposed to removing and replacing the container).
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${calc:benefit_current_sum}${calc:benefit_current_sum, projection=Probable, scale=0.001, unit=k, dec=2}${calc:benefit_current_sum, raw}
BenefitProposedSumTotalOverPeriodTag
The BenefitProposedSumTotalOverPeriodTag class is applied to
PowerPoint Report Templates when the following text is found in a text box:
${calc:benefit_proposed_sum_over_period} where
benefit_proposed_sum_over_period returns the total sum of all monetary benefits
proposed values including recurrence over analysis period. The text will be
replaced in-line (as opposed to removing and replacing the container).
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${calc:benefit_proposed_sum_over_period}${calc:benefit_proposed_sum_over_period, projection=Probable, scale=0.001, unit=k, dec=2}${calc:benefit_proposed_sum_over_period, raw}
BenefitProposedSumTotalTag
The BenefitProposedSumTotalTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${calc:benefit_proposed_sum} where benefit_proposed_sum returns
the total sum of all benefits proposed values. The text will be replaced
in-line (as opposed to removing and replacing the container).
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${calc:benefit_proposed_sum}${calc:benefit_proposed_sum, projection=Probable, scale=0.001, unit=k, dec=2}${calc:benefit_proposed_sum, raw}
CashFlowTableTag
The CashFlowTableTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${calc:table_cash_flow} where
table_cash_flow will return a Cash flow table.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter headerFg will set the foreground color of the table header to the entered Hex value.
Optional parameter headerBg will set the background color of the table header to the entered Hex value.
Optional parameter textForeGround will set the foreground color of the table rows to the entered Hex value.
Optional parameter textBackground will set the background color of the table rows to the entered Hex value.
Optional parameter subTotalFg will set the foreground color of the table subtotal rows to the entered Hex value.
Optional parameter subTotalBg will set the background color of the table subtotal rows to the entered Hex value.
Optional parameter totalFg will set the foreground color of the table total rows to the entered Hex value.
Optional parameter totalBg will set the background color of the table total rows to the entered Hex value.
Optional parameter theme will set a default background color and text color for all rows (colors overwritten by above options). Accepts the following values:
- light
- dark
The tag is case-insensitive.
See ReportTag for syntax.
Examples:
${calc:table_cash_flow, projection=Conservative}${calc:table_cash_flow, projection=Conservative, theme=dark}
CodnQuarterlyTag
* The CodnQuarterlyTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${calc:codn_q} where codn_q returns current cost of do nothing
quarterly. The text will be replaced in-line (as opposed to removing and
replacing the container).
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter realized will return the realized value if present.
See ReportTag for syntax.
Examples:
${calc:codn_q}${calc:codn_q, scale=0.001, unit=k, dec=2}${calc:codn_q, raw}
CodnTag
* The CodnTag class is applied to PowerPoint Report Templates when
the following text is found in a text box:
${calc:codn} where codn returns current cost of do nothing. The
text will be replaced in-line (as opposed to removing and replacing the
container).
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter realized will return the realized value if present.
See ReportTag for syntax.
Examples:
${calc:codn}${calc:codn, scale=0.001, unit=k, dec=2}${calc:codn, raw}
CompanyNameTag
* The CompanyNameTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${calc:company_name} where company_name returns the user entered company name. The
text will be replaced in-line (as opposed to removing and replacing the
container).
Note: tag requires a text input with the mnemonic tb-companyName.
See ReportTag for syntax.
Examples:
${calc:company_name}
CumulativeBenefitByYearTag
* The CumulativeBenefitByYearTag class is applied to PowerPoint
Report Templates when the following text is found in a text box:
${calc:cumulative_benefit_by_year, year=1} where
cumulative_benefit_by_year, year=1
returns the cumulative benefit by year. The text will be replaced
in-line (as opposed to removing and replacing the container).
Optional parameter year selects year the value should return.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
See ReportTag for syntax.
Examples:
${calc:cumulative_benefit_by_year, year=0}${calc:cumulative_benefit_by_year, year=1, scale=0.001, unit=k, dec=2}${calc:cumulative_benefit_by_year, year=1, raw}
CumulativeBenefitTag
* The CumulativeBenefitTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${calc:cumulative_benefits} where cumulative_benefits returns
the total cumulative benefit for the analysis period based on the projection. The text will be
replaced in-line (as opposed to removing and replacing the container).
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${calc:cumulative_benefits}${calc:cumulative_benefits, projection=Probable, scale=0.001, unit=k, dec=2}${calc:cumulative_benefits, raw}
CumulativeNetBenefitByYearTag
* The CumulativeNetBenefitByYearTag class is applied to PowerPoint
Report Templates when the following text is found in a text box:
${calc:cumulative_net_benefit_by_year} where
cumulative_net_benefit_by_year
returns the cumulative net benefit by year. The text will be replaced
in-line (as opposed to removing and replacing the container).
Optional parameter year selects year the value should return.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
See ReportTag for syntax.
Examples:
${calc:cumulative_net_benefit_by_year, year=0}${calc:cumulative_net_benefit_by_year, year-1, scale=0.001, unit=k, dec=2}${calc:cumulative_net_benefit_by_year, raw, year=0}
CumulativeNetBenefitTag
* The CumulativeNetBenefitTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${calc:cumulative_net_benefit} where cumulative_net_benefit
returns the current cumulative net benefits. The text will be replaced
in-line (as opposed to removing and replacing the container).
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
See ReportTag for syntax.
Examples:
${calc:cumulative_net_benefit}${calc:cumulative_net_benefit, scale=0.001, unit=k, dec=2}
CurrentProjectionTag
* The CurrentProjectionTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${calc:current_projection} where current_projection returns the
label of the users selected projection. The text will be replaced in-line (as
opposed to removing and replacing the container).
See ReportTag for syntax.
Examples:
${calc:current_projection}
DeploymentPeriodTag
The DeploymentPeriodTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${calc:deployment_period} where deployment_period returns the
current deployment period in months. The text will be replaced in-line (as
opposed to removing and replacing the container).
See ReportTag for syntax.
Examples:
${calc:deployment_period}
DirectBenefitRealizationTag
The DirectBenefitRealizationTag class is applied to PowerPoint Report Templates when the
following text is found in a text box:
${calc:direct_benefit_realization} where direct_benefit_realization returns the current direct benefit realization percentage. The
text will be replaced in-line (as opposed to removing and replacing the
container).
See ReportTag for syntax.
Examples:
${calc:direct_benefit_realization}
DiscountRateTag
The DiscountRateTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${calc:discount_rate} where discount_rate returns the current
discount rate. The text will be replaced in-line (as opposed to removing and
replacing the container).
See ReportTag for syntax.
Examples:
${calc:discount_rate}
IndirectBenefitRealizationTag
The IndirectBenefitRealizationTag class is applied to PowerPoint Report Templates when the
following text is found in a text box:
${calc:indirect_benefit_realization} where indirect_benefit_realization returns the current indirect benefit realization percentage. The
text will be replaced in-line (as opposed to removing and replacing the
container).
See ReportTag for syntax.
Examples:
${calc:indirect_benefit_realization}
IndustryTag
* The IndustryTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${calc:industry} where industry returns the
label of the users selected industry. The text will be replaced in-line (as
opposed to removing and replacing the container).
Note: tag requires a text input with the mnemonic tb-industry
See ReportTag for syntax.
Examples:
${calc:industry}
IrrTag
* The IrrTag class is applied to PowerPoint Report Templates when
the following text is found in a text box:
${calc:IRR} where IRR returns the current IRR. The text will be
replaced in-line (as opposed to removing and replacing the container).
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${calc:IRR}${calc:IRR, projection=Conservative}${calc:IRR, raw}
LocationTag
* The LocationTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${calc:location} where location returns the
label of the users selected location. The text will be replaced in-line (as
opposed to removing and replacing the container).
Note: tag depends on a text input with the mnemonic tb-location
See ReportTag for syntax.
Examples:
${calc:location}
NetBenefitByYearTag
The NetBenefitByYearTag class is applied to PowerPoint
Report Templates when the following text is found in a text box:
${calc:net_benefit_by_year, year=1} where
net_benefit_by_year, year=1
returns the net benefit by year. The text will be replaced
in-line (as opposed to removing and replacing the container).
Optional parameter year selects year the value should return.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
See ReportTag for syntax.
Examples:
${calc:net_benefit_by_year, year=0}${calc:net_benefit_by_year, year=1, scale=0.001, unit=k, dec=2}${calc:net_benefit_by_year, raw, year=0}
NpvTag
* The NpvTag class is applied to PowerPoint Report Templates when
the following text is found in a text box:
${calc:NPV} where NPV returns the current NPV. The text will be
replaced in-line (as opposed to removing and replacing the container).
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
See ReportTag for syntax.
Examples:
${calc:NPV}${calc:NPV, scale=0.001, unit=k, dec=2}${calc:NPV, raw}
PaybackTag
* The PaybackTag class is applied to PowerPoint Report Templates when
the following text is found in a text box:
${calc:payback} where payback returns the label for the current payback period. The text will be
replaced in-line (as opposed to removing and replacing the container).
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
See ReportTag for syntax.
Examples:
${calc:payback}
PotentialBenefitTag
* The PotentialBenefitTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${calc:potential_benefit} where potential_benefit returns the
total of the unrealized potential impact of the benefits. The text will be
replaced in-line (as opposed to removing and replacing the container).
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${calc:potential_benefit}${calc:potential_benefit, scale=0.001, unit=k, dec=2}${calc:potential_benefit, raw}
RoiPerYearTag
* The RoiPerYearTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${calc:ROI_per_year} where ROI_per_year returns the ROI per
year. The text will be replaced in-line (as opposed to removing and replacing
the container).
Optional parameter year returns year the value should return. Default is year 1.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
See ReportTag for syntax.
Examples:
${calc:ROI_per_year}${calc:ROI_per_year, year=0}${calc:ROI_per_year, year=5, scale=0.001, unit=k, dec=2}${calc:ROI_per_year, raw, year=0}
RoiTag
* The RoiTag class is applied to PowerPoint Report Templates when
the following text is found in a text box:
${calc:ROI} where ROI returns the current ROI. The text will be
replaced in-line (as opposed to removing and replacing the container).
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${calc:ROI}${calc:ROI, raw}
SimpleRealizationByYearTag
The SimpleRealizationByYearTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${calc:realization_by_year} where realization_by_year returns
the realization by year. The text will be replaced in-line (as opposed to
removing and replacing the container).
Optional parameter year returns year the value should return. Default is year 1.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${calc:realization_by_year}${calc:realization_by_year, year=1}${calc:realization_by_year, year=5, projecton=Conservative}${calc:realization_by_year, raw, year=1}
TemplateModeTag
The TemplateModeTag class is applied to PowerPoint Report Templates when
the following text is found in a text box:
${calc:template_mode} where template_mode returns default
template mode set, or user selected mode if template was set to "User
Select". The text will be replaced in-line (as opposed to removing and
replacing the container).
See ReportTag for syntax.
Examples:
${calc:template_mode}
TotalDirectBenefitsTag
* The TotalDirectBenefitsTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${calc:total_direct_benefits} where total_direct_benefits
returns the total direct benefit. The text will be replaced in-line
(as opposed to removing and replacing the container).
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${calc:total_direct_benefits}${calc:total_direct_benefits, scale=0.001, unit=k, dec=2}${calc:total_direct_benefits, raw}
TotalIndirectBenefitsTag
* The TotalIndirectBenefitsTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${calc:total_indirect_benefits} where total_indirect_benefits
returns the total indirect benefit. The text will be replaced
in-line (as opposed to removing and replacing the container).
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${calc:total_indirect_benefits}${calc:total_indirect_benefits, scale=0.001, unit=k, dec=2}${calc:total_indirect_benefits, raw}
TotalRealizedBenefitsTag
The TotalRealizedBenefitsTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${calc:total_realized_benefits} where total_realized_benefits
returns the total realized benefit for the year. The text will be replaced in-line
(as opposed to removing and replacing the container).
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter year the year the value should return. Default is year 1.
See ReportTag for syntax.
Examples:
${calc:total_realized_benefits, year=1}${calc:total_realized_benefits, scale=0.001, unit=k, dec=2}${calc:total_realized_benefits, raw, year=1}
BenefitAnnualGrowthRateTag
* The BenefitAnnualGrowthRateTag class is applied to PowerPoint
Report Templates when the following text is found in a text box:
${benefit:annual_growth_rate} where annual_growth_rate returns the
annual growth rate of the benefit.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${benefit:annual_growth_rate, mnemonic=benefit1}${benefit:annual_growth_rate, id=7}${benefit:annual_growth_rate, raw, mnemonic=benefit1}
BenefitAverageIdealTotalTag
The BenefitAverageIdealTotalTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${benefit:average_ideal_total} where average_ideal_total
returns the average ideal total over the analysis period based on the
projection.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${benefit:average_ideal_total, mnemonic=benefit1}${benefit:average_ideal_total, id=7, scale=0.001, unit=k, dec=2}${benefit:average_ideal_total, raw, mnemonic=benefit1}
BenefitAverageRealizedTotalTag
The BenefitAverageRealizedTotalTag class is applied to PowerPoint
Report Templates when the following text is found in a text box:
${benefit:average_realized_total} where average_realized_total
returns the average realized total over the analysis period based on the
projection.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${benefit:average_realized_total, mnemonic=benefit1}${benefit:average_realized_total, id=7, scale=0.001, unit=k, dec=2}${benefit:average_realized_total, raw, mnemonic=benefit1}
BenefitBenefitTextTag
* The BenefitBenefitTextTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${benefit:benefit_text} where benefit_text returns the benefit
text of the benefit.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter asHTML will insert the contents as formatted HTML.
See ReportTag for syntax.
Examples:
${benefit:benefit_text, mnemonic=benefit1}${benefit:benefit_text, id=7}
BenefitCalcTableTag
The BenefitCalcTableTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${benefit:table_calc} where table_calc will return a table of
the benefit calculator.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter headerFg will set the foreground color of the table header to the entered Hex value.
Optional parameter headerBg will set the background color of the table header to the entered Hex value.
Optional parameter textForeGround will set the foreground color of the table rows to the entered Hex value.
Optional parameter textBackground will set the background color of the table rows to the entered Hex value.
Optional parameter subTotalFg will set the foreground color of the table subtotal rows to the entered Hex value.
Optional parameter subTotalBg will set the background color of the table subtotal rows to the entered Hex value.
Optional parameter totalFg will set the foreground color of the table total rows to the entered Hex value.
Optional parameter totalBg will set the background color of the table total rows to the entered Hex value.
Optional parameter theme will set a default background color and text color for all rows (colors overwritten by above options). Accepts the following values:
- light
- dark
Optional parameter hideFormula will not show total formula in table.
The tag is case-insensitive.
See ReportTag for syntax.
Examples:
${benefit:table_calc, id=1, projection=Conservative}${benefit:table_calc, id=1 headerFg=#E0E0E0, headerBg=#11a6c0}${benefit:table_calc, mnemonic=benefit1, theme=dark}
BenefitCalloutTag
The BenefitCalloutTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${benefit:callout, row=[row id], column=[property]} where
callout returns the information related to a benefit callout.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Required parameter row is the row identifier for the callout.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection.
Optional parameter column is the property column for the callout (e.g. label, tooltip, value). Default is the callouts label / display name
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${benefit:callout, mnemonic=benefit1, row=A, column=label}${benefit:callout, mnemonic=benefit1, row=A, column=tooltip}${benefit:callout, mnemonic=benefit1, row=A, column=value, projection=probable}${benefit:callout, id=7, row=A}${benefit:callout, raw, mnemonic=benefit1, row=A, column=value}
BenefitChallengeTextTag
* The BenefitChallengeTextTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${benefit:challenge_text} where challenge_text returns the
challenge text of the benefit.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter asHTML will insert the contents as formatted HTML.
See ReportTag for syntax.
Examples:
${benefit:challenge_text, mnemonic=benefit1}${benefit:challenge_text, id=7}
BenefitComprehensiveRealizationTag
* The BenefitComprehensiveRealizationTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${benefit:comprehensive_realization} where comprehensive_realization returns the
comprehensive realization of the benefit.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${benefit:comprehensive_realization, mnemonic=benefit1}${benefit:comprehensive_realization, id=7}${benefit:comprehensive_realization, raw, mnemonic=benefit1}
BenefitDeploymentTimeTag
* The BenefitDeploymentTimeTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${benefit:deployment_time} where deployment_time returns the
time to deploy in months of the benefit.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
See ReportTag for syntax.
Examples:
${benefit:deployment_time, mnemonic=benefit1}${benefit:deployment_time, id=7}
BenefitDescriptionTag
* The BenefitDescriptionTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${benefit:description} where description returns the
description of the benefit.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
See ReportTag for syntax.
Examples:
${benefit:description, mnemonic=benefit1}${benefit:description, id=7}
BenefitIconTag
The BenefitIconTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${benefit:icon,id=benefitId} where benefitId is a valid benefit
id. It will display the benefit icon.
Parameter id is required. Optional parameters include fit, scalex, and scaley. fit will generate an image that will fit inside the container and fill either the height or width of the container depending on the icon's scale ratio. scalex will generate an image as wide as the container with a proportional height, and scaley will generate an image as tall as the container with a proportional width. If both scalex and scaley are included, only scalex will be applied.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${benefit:icon,id=benefitId}${benefit:icon,id=benefitId, fit}${benefit:icon,id=benefitId, scalex}${benefit:icon,id=benefitId, scaley}
BenefitIdByRankTag
The BenefitIdByRankTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${benefit:id_by_rank} where id_by_rank
returns the id of a selected benefit based on the rank of its impact value. i.e.
Highest or Lowest value
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Required parameter top or bottom a number which the id returned is ranked by. If the rank entered is beyond scope of benefits the next rank is returned.
Optional parameter filter accepts the value passed in, either Monetary or Non_Monetary. Monetary is default.
See ReportTag for syntax.
Examples:
${benefit:id_by_rank, top=3}${benefit:id_by_rank, projection=Optimistic, bottom=2}
BenefitImpactRealizedTag
The BenefitImpactRealizedTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${benefit:impact_realized} where impact_realized returns the realized impact
of the benefit based on the projection.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter year returns year the value should return. Default is year 1.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${benefit:impact_realized, mnemonic=benefit1}${benefit:impact_realized, id=7, scale=0.001, unit=k, dec=2}${benefit:impact_realized, raw, mnemonic=benefit1}
BenefitImpactUnrealizedTag
* The BenefitImpactUnrealizedTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${benefit:impact_unrealized} where impact_unrealized returns the unrealized impact
of the benefit based on the projection.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter year returns year the value should return. Default is year 1.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${benefit:impact_unrealized, mnemonic=benefit1}${benefit:impact_unrealized, id=7, scale=0.001, unit=k, dec=2}${benefit:impact_unrealized, raw, mnemonic=benefit1}
BenefitIsIncludedTag
* The BenefitIsIncludedTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${benefit:included} where included returns true or false if the
benefit was included in the value summary
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
See ReportTag for syntax.
Examples:
${benefit:included, mnemonic=benefit1}${benefit:included, id=7}
BenefitLineItemTag
The BenefitLineItemTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${benefit:line_item, row=[row id], column=[column label]} where
line_item returns the information related to the benefit line item.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Required parameter row is the row identifier for the line item.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection.
Optional parameter column is the column label for the line item (e.g. label, current, impact, proposed). Default is the line items label / display name
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${benefit:line_item, mnemonic=benefit1, row=A, column=label}${benefit:line_item, mnemonic=benefit1, row=A, column=proposed, projection=probable}${benefit:line_item, id=7}${benefit:line_item, mnemonic=benefit1, raw, row=A, column=proposed}
BenefitNameTag
* The BenefitNameTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${benefit:name} where name returns the label name of the
benefit.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.
See ReportTag for syntax.
Examples:
${benefit:name, mnemonic=benefit1}${benefit:name, id=7}
BenefitProposedTotalTag
The BenefitProposedTotalTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${benefit:proposed_total} where proposed_total returns
the proposed total value of the benefit based on the projection.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${benefit:proposed_total, mnemonic=benefit1}${benefit:proposed_total, id=7, scale=0.001, unit=k, dec=2}${benefit:proposed_total, raw, mnemonic=benefit1}
BenefitQuarterlySummaryTableTag
The BenefitQuarterlySummaryTableTag class is applied to PowerPoint
Report Templates when the following text is found in a text box:
${benefit:table_quarterly_summary} where
table_quarterly_summary will return a table of the benefit quarterly
summary, including realization and deployment offset.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter headerFg will set the foreground color of the table header to the entered Hex value.
Optional parameter headerBg will set the background color of the table header to the entered Hex value.
Optional parameter textForeGround will set the foreground color of the table rows to the entered Hex value.
Optional parameter textBackground will set the background color of the table rows to the entered Hex value.
Optional parameter subTotalFg will set the foreground color of the table subtotal rows to the entered Hex value.
Optional parameter subTotalBg will set the background color of the table subtotal rows to the entered Hex value.
Optional parameter totalFg will set the foreground color of the table total rows to the entered Hex value.
Optional parameter totalBg will set the background color of the table total rows to the entered Hex value.
Optional parameter theme will set a default background color and text color for all rows (colors overwritten by above options). Accepts the following values:
- light
- dark
The tag is case-insensitive.
See ReportTag for syntax.
Examples:
${benefit:table_quarterly_summary, id=1, projection=Conservative}${benefit:table_quarterly_summary, id=1 headerFg=#E0E0E0, headerBg=#11a6c0}${benefit:table_quarterly_summary, mnemonic=benefit1, theme=dark}
BenefitRealizationByYearTag
The BenefitRealizationByYearTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${benefit:realization_by_year} where realization_by_year
returns the realization by year of the benefit based on the projection.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter year returns year the value should return. Default is year 1.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${benefit:realization_by_year, mnemonic=benefit1}${benefit:realization_by_year, id=7}${benefit:realization_by_year, id=7, year=1, projection=probable}${benefit:realization_by_year, raw, mnemonic=benefit1}
BenefitRealizationTableTag
The BenefitRealizationTableTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${benefit:table_realization} where table_realization will
return a table of the realization summary for a benefit
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter headerFg will set the foreground color of the table header to the entered Hex value.
Optional parameter headerBg will set the background color of the table header to the entered Hex value.
Optional parameter textForeGround will set the foreground color of the table rows to the entered Hex value.
Optional parameter textBackground will set the background color of the table rows to the entered Hex value.
Optional parameter subTotalFg will set the foreground color of the table subtotal rows to the entered Hex value.
Optional parameter subTotalBg will set the background color of the table subtotal rows to the entered Hex value.
Optional parameter totalFg will set the foreground color of the table total rows to the entered Hex value.
Optional parameter totalBg will set the background color of the table total rows to the entered Hex value.
Optional parameter theme will set a default background color and text color for all rows (colors overwritten by above options). Accepts the following values:
- light
- dark
The tag is case-insensitive.
See ReportTag for syntax.
Examples:
${benefit:table_realization, id=1,}${benefit:table_realization, id=1 headerFg=#E0E0E0, headerBg=#11a6c0}${benefit:table_realization, mnemonic=benefit1, theme=dark}
BenefitTotalRealizedImpactTag
The BenefitTotalRealizedImpactTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${benefit:total_realized_impact} where total_realized_impact returns the total realized impact
of the benefit based on the projection.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${benefit:total_realized_impact, mnemonic=benefit1}${benefit:total_realized_impact, id=7, scale=0.001, unit=k, dec=2}${benefit:total_realized_impact, raw, mnemonic=benefit1}
BenefitValueTotal
The BenefitValueTotal class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${benefit:value_total} where value_total returns the current total
value of the benefit based on the projection.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${benefit:value_total, mnemonic=benefit1}${benefit:value_total, id=7, scale=0.001, unit=k, dec=2}${benefit:value_total, raw, mnemonic=benefit1}
ChallengeNameTag
* The ChallengeNameTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${challenge:name} where name returns the label name of the
challenge. The text will be replaced in-line (as opposed to removing and
replacing the container).
parameter id the id number of the challenge.
parameter mnemonic the mnemonic of the challenge.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.
See ReportTag for syntax.
Examples:
${challenge:name, id=3}${challenge:name, mnemonic=challenge3}
ChallengeTooltipTag
The ChallengeTooltipTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${challenge:tooltip} where tooltip returns the tool tip of the
challenge. The text will be replaced in-line (as opposed to removing and
replacing the container).
parameter id the id number of the challenge.
parameter mnemonic the mnemonic of the challenge.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.
See ReportTag for syntax.
Examples:
${challenge:tooltip, id=3}${challenge:tooltip, mnemonic=challenge3}
ChallengeValueTag
The ChallengeValueTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${challenge:value} where value returns the label value of the
challenge. The text will be replaced in-line (as opposed to removing and
replacing the container).
parameter id the id number of the challenge.
parameter mnemonic the mnemonic of the challenge.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter raw will return the value in default English (e.g. top, high, none). Commonly used in conjuction with evaluate or action tags.
See ReportTag for syntax.
Examples:
${challenge:value, id=3}${challenge:value, mnemonic=challenge3}
TickboxNameTag
The TickboxNameTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${tickbox:name} where name returns the label of the tickbox.
required parameter mnemonic the mnemonic of the tickbox.
Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.
See ReportTag for syntax.
Examples:
${tickbox:name, mnemonic=tickbox1}
TickboxTickedTag
The TickboxTickedTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${tickbox:checked} where checked will return true or false if
the check box was checked in the application.
${tickbox:unchecked} where unchecked returns true or false if
the check box was unchecked in the application.
required parameter mnemonic the mnemonic of the tickbox.
See ReportTag for syntax.
Examples:
${tickbox:checked, mnemonic=tickbox1}${tickbox:unchecked, mnemonic=tickbox1}
TickboxTooltipTag
The TickboxTooltipTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${tickbox:tooltip} where tooltip returns tool tip of the
tickbox.
required parameter mnemonic the mnemonic of the tickbox.
Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.
See ReportTag for syntax.
Examples:
${tickbox:tooltip, mnemonic=tickbox1}
EvaluateAndTag
The EvaluateAndTag class is applied to PowerPoint Report Templates
when the following text is found:
${eval:and, tags=[{Tag value}], compareTo={comparison}} where
tags will be be compared to the {comparison}. Returns true
if all tags are equal to the comparison value. Can be used in conjuction with
${eval:gt}, ${eval:lt}, and ${eval:eq} nested within tags.
Note if wanting to check if multiple options were used in a Select item
it may be easier to use
SelectValueIncludedTag
instead with the include=all parameter.
required attribute tags accepts multiple valid report tags. Tags passed in must be surrounded by [ ] brackets and ; separated. Tags passed in should evaluate to true or false for best results in comparison.
required attribute compareTo accepts either text or number or a valid tag that will evaluate to text or number.
See ReportTag for syntax.
Examples:
${eval:and, tags=[${eval:gt, tag=${calc:analysis_period}, compareTo=3}; ${tickbox:checked, mnemonic=tickbox1}]}
EvaluateEqualsTag
The EvaluateEqualsTag class is applied to PowerPoint Report Templates
when the following text is found:
${eval:eq, tag={Tag value}, compareTo={comparison}} where a
tag can be compared to the {comparison}. Returns true if tag is
equal to comparison value
required attribute tag accepts a valid report tag. Tag can evaluate to either text or number
required attribute compareTo accepts either text or number or a valid tag that will evaluate to text or number.
optional attribute dec accepts a number to be used to round values when comparing.
See ReportTag for syntax.
Examples:
${eval:eq, tag=${calc:analysis_period}, compareTo=4}${eval:eq, tag=${global:current_value, raw}, compareTo=300, dec=0}
EvaluateGreaterThanTag
The EvaluateGreaterThanTag class is applied to PowerPoint Report
Templates when the following text is found:
${eval:gt, tag={Tag value}, compareTo={comparison}} where a {Tag
value} can be compared to the {comparison}. Returns true if tag
is greater than comparison value
required attribute tag accepts a valid report tag that evaluates to a number. Raw attribute recommended for nested tag to compare numbers without formatting
required attribute compareTo accepts a number or a valid tag that will evaluate to a number to be used to compare to tag. Raw attribute recommended for nested tag to compare numbers without formatting.
optional attribute dec accepts a number to be used to round values when comparing.
See ReportTag for syntax.
Examples:
${eval:gt, tag=${calc:analysis_period}, compareTo=4}${eval:gt, tag=${global:current_value, raw}, compareTo=300, dec=0}
EvaluateLessThanTag
The EvaluateLessThanTag class is applied to PowerPoint Report
Templates when the following text is found:
${eval:lt, tag={Tag value}, compareTo={comparison}} where a
{Tag value} can be compared to the {comparison}. Returns true if tag is
less than comparison value
required attribute tag accepts a valid report tag that evaluates to a number. Raw attribute recommended for nested tag to compare numbers without formatting
required attribute compareTo accepts a number or a valid tag that will evaluate to a number to be used to compare to tag. Raw attribute recommended for nested tag to compare numbers without formatting.
optional attribute dec accepts a number to be used to round values when comparing.
See ReportTag for syntax.
Examples:
${eval:lt, tag=${calc:analysis_period}, compareTo=4}${eval:lt, tag=${global:current_value, raw}, compareTo=300, dec=0}
EvaluateNotEqualsTag
The EvaluateNotEqualsTag class is applied to PowerPoint Report
Templates when the following text is found:
${eval:neq, tag={Tag value}, compareTo={comparison}} where a
Tag value can be compared to the {comparison}. Returns true if tag is
not equal to comparison value
required attribute tag accepts a valid report tag that evaluates to a number. Raw attribute recommended for nested tag to compare numbers without formatting
required attribute compareTo accepts a number or a valid tag that will evaluate to a number to be used to compare to tag. Raw attribute recommended for nested tag to compare numbers without formatting.
optional attribute dec accepts a number to be used to round values when comparing.
See ReportTag for syntax.
Examples:
${eval:neq, tag=${calc:analysis_period}, compareTo=4}${eval:neq, tag=${global:current_value, raw}, compareTo=300, dec=0}
EvaluateOrTag
The EvaluateOrTag class is applied to PowerPoint Report Templates
when the following text is found:
${eval:or, tags=[{Tag value}], compareTo={comparison}} where
tags will be be compared to the {comparison}. Returns true
if any tag is equal to comparison value. Can be used in conjuction with
${eval:gt}, ${eval:lt}, and ${eval:eq} nested within tags.
Note if wanting to check if multiple options were used in a Select item it
may be easier to use
SelectValueIncludedTag
instead.
required attribute tags accepts multiple valid report tags. Tags passed in must be surrounded by [ ] brackets and ; separated. Tags passed in should evaluate to true or false for best results in comparison.
required attribute compareTo accepts either text or number or a valid tag that will evaluate to text or number.
See ReportTag for syntax.
Examples:
${eval:and, tags=[${eval:gt, tag=${calc:analysis_period}, compareTo=3}; ${tickbox:checked, mnemonic=tickbox1}]}
GlobalVariableCurrentValueTag
The GlobalVariableCurrentValueTag class is applied to PowerPoint
Report Templates when the following text is found in a text box:
${global:current_value} where current_value returns the current
value of the global variable.
parameter id the id number of the global variable.
parameter mnemonic the mnemonic of the global variable.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${global:current_value, mnemonic=gv1}${global:current_value, id=7}${global:current_value, mnemonic=gv1, scale=0.001, unit=k, dec=2}${global:current_value, mnemonic=gv1, raw}
GlobalVariableImpactValuetag
The GlobalVariableImpactValuetag class is applied to PowerPoint
Report Templates when the following text is found in a text box:
${global:impact_value} where impact_value returns the default
set impact value of the global variable. For impact values associated via a
benefit line item see
BenefitLineItemTag
parameter id the id number of the global variable.
parameter mnemonic the mnemonic of the global variable.
Only one parameter is required for the tag, while the other can be omitted.
optional parameter projection the projection value to return. Defaults to analysis current selected projection.
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${global:impact_value, mnemonic=gv1, projection=Conservative}${global:impact_value, id=7}${global:impact_value, mnemonic=gv1, raw}
GlobalVariableLabelTag
The GlobalVariableLabelTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${global:label} where label returns the label name of the
global variable.
parameter id the id number of the global variable.
parameter mnemonic the mnemonic of the global variable.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.
See ReportTag for syntax.
Examples:
${global:label, mnemonic=gv1}${global:label, id=7}
GlobalVariableProposedValueTag
The GlobalVariableProposedValueTag class is applied to PowerPoint
Report Templates when the following text is found in a text box:
${global:proposed_value} where proposed_value returns the
default set proposed value of the global variable. For impact values
associated via a benefit line item see
BenefitLineItemTag
parameter id the id number of the global variable.
parameter mnemonic the mnemonic of the global variable.
Only one parameter is required for the tag, while the other can be omitted.
optional parameter projection the projection value to return. Defaults to analysis current selected projection.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${global:proposed_value, mnemonic=gv1, projection=Conservative}${global:proposed_value, id=7}${global:proposed_value, id=7, scale=0.001, unit=k, dec=2}${global:proposed_value, mnemonic=gv1, raw}
GlobalVariableTooltipTag
The GlobalVariableTooltipTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${global:tooltip} where tooltip returns the tool tip of the
global variable.
parameter id the id number of the global variable.
parameter mnemonic the mnemonic of the global variable.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.
See ReportTag for syntax.
Examples:
${global:tooltip, mnemonic=gv1}${global:tooltip, id=7}
InvestmentAnnualTotalTag
* The InvestmentAnnualTotalTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${investment:invested_annual_total} where invested_annual_total returns the
total annual investment for the specified year. The text will be replaced in-line (as opposed to
removing and replacing the container).
Parameter year returns year the value should return.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${investment:invested_annual_total, year=1}${investment:invested_annual_total, year=1, scale=0.001, unit=k, dec=2}${investment:invested_annual_total, year=1, raw}
InvestmentAnnualValueTag
The InvestmentAnnualValueTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${investment:annual_value} where annual_value returns the
annual value of the investment. The text will be replaced in-line (as opposed
to removing and replacing the container).
parameter id the id number of the investment.
parameter mnemonic the mnemonic of the investment.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter year returns year the value should return. Default is the initial value (e.g. year 0).
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${investment:annual_value, id=[investmentid]}${investment:annual_value, mnemonic=invest1, year=1}${investment:annual_value, id=123, scale=0.001, unit=k, dec=2}${investment:annual_value, mnemonic=invest1, year=1, raw}
InvestmentCumulativeTotalTag
The InvestmentCumulativeTotalTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${investment:cumulative_total} where cumulative_total returns the
cumulative total of the investment. The text will be replaced in-line (as opposed
to removing and replacing the container).
parameter id the id number of the investment.
parameter mnemonic the mnemonic of the investment.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${investment:cumulative_total, id=[investmentid]}${investment:cumulative_total, mnemonic=invest1}${investment:cumulative_total, id=123, scale=0.001, unit=k, dec=2}${investment:cumulative_total, mnemonic=invest1, raw}
InvestmentNameTag
The InvestmentName class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${investment:name} where name returns the label of the
investment.
parameter id the id number of the investment.
parameter mnemonic the mnemonic of the investment.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${investment:name,id=1}${investment:name,id=[investmentid]}- When used inside of a duplicate slide or duplicate section tag.
InvestmentTooltipTag
The InvestmentTooltipTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${investment:tooltip,id=investmentid} where tooltip returns the
tool tip of the investment.
parameter id the id number of the investment.
parameter mnemonic the mnemonic of the investment.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${investment:tooltip,id=1}${investment:tooltip,id=[investmentid]}- When used inside of a duplicate slide or duplicate section tag.
InvestmentTotalTag
* The InvestmentTotalTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${investment:invested_total} where invested_total returns the
total cumulative investment. The text will be replaced in-line (as opposed to
removing and replacing the container).
Optional parameter year returns year the value should return. Default is the analysis period.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${investment:invested_total}${investment:invested_total, year=1}${investment:invested_total, scale=0.001, unit=k, dec=2}${investment:invested_total, year=1, raw}
InvestmentsIncludedTag
* The InvestmentsIncludedTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${investment:investments_included} where investments_included
returns true or false if the investments are included. The text will be
replaced in-line (as opposed to removing and replacing the container).
See ReportTag for syntax.
Examples:
${investment:investments_included}
KeyPerformanceIndicatorCurrentValueTag
The KeyPerformanceIndicatorCurrentValueTag class is applied to
PowerPoint Report Templates when the following text is found in a text box:
${kpi:current_value} where current_value returns the current
value of the KPI.
parameter id the id number of the KPI.
parameter mnemonic the mnemonic of the KPI.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${kpi:current_value, mnemonic=kpi1}${kpi:current_value, id=7}
KeyPerformanceIndicatorNameTag
The KeyPerformanceIndicatorNameTag class is applied to PowerPoint
Report Templates when the following text is found in a text box:
${kpi:name} where name returns the label name of the KPI.
parameter id the id number of the KPI.
parameter mnemonic the mnemonic of the KPI.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.
See ReportTag for syntax.
Examples:
${kpi:name, mnemonic=kpi1}${kpi:name, id=7}
KeyPerformanceIndicatorOriginalValueTag
The KeyPerformanceIndicatorOriginalValueTag class is applied to
PowerPoint Report Templates when the following text is found in a text box:
${kpi:original_value} where original_value returns the original
value of the KPI.
parameter id the id number of the KPI.
parameter mnemonic the mnemonic of the KPI.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${kpi:original_value, mnemonic=kpi1}${kpi:original_value, id=7}
KeyPerformanceIndicatorTargetValueTag
The KeyPerformanceIndicatorTargetValueTag class is applied to
PowerPoint Report Templates when the following text is found in a text box:
${kpi:target_value} where target_value returns the target value
of the KPI.
parameter id the id number of the KPI.
parameter mnemonic the mnemonic of the KPI.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
See ReportTag for syntax.
Examples:
${kpi:target_value, mnemonic=kpi1}${kpi:target_value, id=7}
KeyPerformanceIndicatorTooltipTag
The KeyPerformanceIndicatorTooltipTag class is applied to PowerPoint
Report Templates when the following text is found in a text box:
${kpi:tooltip} where tooltip returns the tooltip of the KPI.
parameter id the id number of the KPI.
parameter mnemonic the mnemonic of the KPI.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.
See ReportTag for syntax.
Examples:
${kpi:tooltip, mnemonic=kpi1}${kpi:tooltip, id=7}
AnalysisLanguageCodeTag
The AnalysisLanguageCodeTag class is applied to Report Templates when
the following text is found:
${language:code} where code returns the iso code of the
language
See ReportTag for syntax.
Example:
${language:code}
AnalysisLanguageNameTag
The AnalysisLanguageNameTag class is applied to Report Templates when
the following text is found:
${language:name} where name returns the name of the
language
See ReportTag for syntax.
Example:
RichTextEditorHtmlTag
The RichTextEditorHtmlTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${richText:html} where html returns the user entered text (i.e.
text input). If the text box is single line then the text will be replaced
in-line (as opposed to removing and replacing the container).
parameter id the id number of the rich text editor.
parameter mnemonic the mnemonic of the rich text editor.
Only one parameter is required for the tag, while the other can be omitted.
See ReportTag for syntax.
Examples:
${richText:html, mnemonic=rte1}${richText:html, id=7}
RichTextEditorNameTag
The RichTextEditorNameTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${richText:name} where name returns the label name of the rich
text editor (i.e. text input)
parameter id the id number of the rich text editor.
parameter mnemonic the mnemonic of the rich text editor.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.
See ReportTag for syntax.
Examples:
${richText:name, mnemonic=kpi1}${richText:name, id=7}
SelectNameTag
The SelectNameTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${select:name} where name returns the label name of the Select.
parameter id the id number of the Select.
parameter mnemonic the mnemonic of the Select.
Only one parameter is required for the tag, while the other can be omitted.
Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.
See ReportTag for syntax.
Examples:
${select:name, mnemonic=select1}${select:name, id=7}
SelectValueIncludedTag
The SelectValueIncludedTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${select:value_included} where value_included returns true if
the values were selected by the user. The text will be replaced in-line (as
opposed to removing and replacing the container).
parameter id the id number of the select.
parameter mnemonic the mnemonic of the select.
Only one parameter is required for the tag, while the other can be omitted.
Required parameter values. The set of values to test if they were selected. The values require being surrounded by [] square brackets and must be semi-colon ; separated.
Optional parameter include. Determines if the tag should check if all values or any single value was selected. Accepts the following values:
- all (all matching values must be selected to return true)
- any (any of the matching values were selected to return true. Default behavior)
See ReportTag for syntax.
Examples:
${select:value_included, id=3, values=[option1;option2]}${select:value_included, mnemonic=select3, values=[option1;option2; option3]}${select:value_included, mnemonic=select3, include=all, values=[option1;option2]}${select:value_included, mnemonic=select3, include=any, values=[option1;option2]}
SelectValueSelectedTag
The SelectValueSelectedTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${select:value_selected} where value_selected returns the
value(s) that were selected by the user. The text will be replaced in-line
(as opposed to removing and replacing the container).
parameter id the id number of the select.
parameter mnemonic the mnemonic of the select.
Only one parameter is required for the tag, while the other can be omitted.
optional parameter useLabel. If set to true, will display selected options label instead of value. Defaults to false
optional parameter display. If set to list, will display selected options as a bulleted list. Defaults to inline where options are comma separated
See ReportTag for syntax.
Examples:
${select:value_selected, id=3}${select:value_selected, mnemonic=select1}${select:value_selected, mnemonic=select3, useLabel=true, display=list}
SummaryModelDurationYearsTag
The SummaryModelDurationYearsTag class is applied to Report Templates
when the following text is found in a text box:
${summary_model:duration_years} where duration_years returns
the duration in years of the summary model.
Examples:
${summary_model:duration_years}
SummaryModelIrrTag
The SummaryModelIrrTag class is applied to Report Templates when the
following text is found in a text box:
${summary_model:irr} where irr returns the Internal rate of
return of the summary model.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
See ReportTag for syntax.
Examples:
${summary_model:irr}
SummaryModelNpvTag
The SummaryModelNpvTag class is applied to Report Templates when the
following text is found in a text box:
${summary_model:npv} where npv returns the total Net present value of the summary
model.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
See ReportTag for syntax.
Examples:
${summary_model:npv}
SummaryModelPaybackPeriodTag
The SummaryModelPaybackPeriodTag class is applied to Report Templates
when the following text is found in a text box:
${summary_model:payback_period} where payback_period returns
the payback period in months of the summary model.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
See ReportTag for syntax.
Examples:
${summary_model:payback_period}
SummaryModelRoiTag
The SummaryModelRoiTag class is applied to Report Templates when the
following text is found in a text box:
${summary_model:roi} where roi returns the Return on Investment
of the summary model.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
See ReportTag for syntax.
Examples:
${summary_model:roi}
SummaryModelTotalBenefitsRealizedTag
The SummaryModelTotalBenefitsRealizedTag class is applied to Report
Templates when the following text is found in a text box:
${summary_model:total_benefit_realized} where
total_benefit_realized returns the total realized benefit of the
summary model.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
See ReportTag for syntax.
Examples:
${summary_model:total_benefit_realized}
SummaryModelTotalInvestmentDiscountedTag
The SummaryModelTotalInvestmentDiscountedTag class is applied to
Report Templates when the following text is found in a text box:
${summary_model:total_investment_discounted} where
total_investment_discounted returns the total investment with discount
applied for the summary model.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
See ReportTag for syntax.
Examples:
${summary_model:total_investment_discounted}
SummaryModelTotalInvestmentTag
The SummaryModelTotalInvestmentTag class is applied to Report Templates when the
following text is found in a text box:
${summary_model:total_investment} where total_investment returns the total investment of the summary model.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
See ReportTag for syntax.
Examples:
${summary_model:total_investment}
ClientFirstNameTag
The ClientFirstNameTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${db:client_first}.
It will display the client/recipient first name from the Generate Report
Modal in the application inline (as opposed to removing and replacing the
container).
If targeting a custom text field instead see
RichTextEditorHtmlTag
There are no optional parameters.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${db:client_first}
ClientLastNameTag
The ClientLastNameTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${db:client_last}.
It will display the client/recipient last name from the Generate Report
Modal in the application inline (as opposed to removing and replacing the
container).
If targeting a custom text field instead see
RichTextEditorHtmlTag
There are no optional parameters.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${db:client_last}
ClientPhoneTag
The ClientPhoneTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${db:client_phone}.
It will display the client/recipient phone number from the Generate Report
Modal in the application inline (as opposed to removing and replacing the
container).
If targeting a custom text field instead see
RichTextEditorHtmlTag
There are no optional parameters.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${db:client_phone}
ClientTitleTag
The ClientTitleTag class is applied to PowerPoint Report Templates when
the following text is found in a text box:
${db:client_title}.
It will display the client/recipient title from the Generate Report
Modal in the application inline (as opposed to removing and replacing the
container).
If targeting a custom text field instead see
RichTextEditorHtmlTag
There are no optional parameters.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${db:client_title}
RepFirstNameTag
The RepFirstNameTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${db:rep_first}.
It will display the sales representative first name from the Generate Report
Modal in the application inline (as opposed to removing and replacing the
container).
If targeting a custom text field instead see
RichTextEditorHtmlTag
There are no optional parameters.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${db:rep_first}
RepLastNameTag
The RepLastNameTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${db:rep_last}.
It will display the sales representative last name from the Generate Report
Modal in the application inline (as opposed to removing and replacing the
container).
If targeting a custom text field instead see
RichTextEditorHtmlTag
There are no optional parameters.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${db:rep_last}
RepPhoneTag
The RepPhoneTag class is applied to PowerPoint Report Templates when
the following text is found in a text box:
${db:rep_phone}.
It will display the sales representative phone number from the Generate
Report Modal in the application inline (as opposed to removing and replacing
the container).
If targeting a custom text field instead see
RichTextEditorHtmlTag
There are no optional parameters.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${db:rep_phone}
RepTitleTag
The RepTitleTag class is applied to PowerPoint Report Templates when
the following text is found in a text box:
${db:rep_title}.
It will display the sales representative title from the Generate
Report Modal in the application inline (as opposed to removing and replacing
the container).
If targeting a custom text field instead see
RichTextEditorHtmlTag
There are no optional parameters.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${db:rep_title}
TargetEmailTag
The TargetEmailTag class is applied to PowerPoint Report Templates
when the following text is found in a text box:
${db:target_email}.
It will display the target email from the Generate
Report Modal in the application inline (as opposed to removing and replacing
the container).
If targeting a custom text field instead see
RichTextEditorHtmlTag
There are no optional parameters.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${db:target_email}
UserEmailTag
The UserEmailTag class is applied to PowerPoint Report Templates when
the following text is found in a text box:
${db:user_email}. It will display the logged in user who generated the report's
email address inline (as opposed to removing and replacing the container).
There are no optional parameters.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${db:user_email}
UserFirstTag
The UserFirstTag class is applied to PowerPoint Report Templates when
the following text is found in a text box:
${db:user_first}. It will display the logged in user who generated the report's
first name inline (as opposed to removing and replacing the container).
There are no optional parameters.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${db:user_first}
UserLastTag
The UserLastTag class is applied to PowerPoint Report Templates when
the following text is found in a text box:
${db:user_last}. It will display the logged in user who generated the report's
last name inline (as opposed to removing and replacing the container).
There are no optional parameters.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${db:user_last}
ValueMapCategoryAnnualIdealBenefitTag
The ValueMapCategoryAnnualIdealBenefitTag class is applied to
PowerPoint Report Templates when the following text is found in a text box:
${vmc:annualIdealBenefit, id=[vmcid]} where
[vmcid] is a valid value map category id. It will display
the Annual ideal benefit in-line (as opposed to removing and replacing the
container).
Parameter id is required. There are no optional parameters.
Below options only available in Tool builder v8+
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter year returns year the value should return. Default is year 1.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${vmc:annualIdealBenefit,id=[vmcid]}${vmc:annualIdealBenefit,id=123, year=1}${vmc:annualIdealBenefit,id=123, scale=0.001, unit=k, dec=2}${vmc:annualIdealBenefit,id=123, year=1, raw}
ValueMapCategoryAnnualRealizedBenefitTag
The ValueMapCategoryAnnualRealizedBenefitTag class is applied to
PowerPoint Report Templates when the following text is found in a text box:
${vmc:annualRealizedBenefit, id=[vmcid]} where
[vmcid] is a valid value map category id. It will display
the Annual realized benefit in-line (as opposed to removing and replacing the
container).
Parameter id is required. There are no optional parameters.
Below options only available in Tool builder v8+
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter year returns year the value should return. Default is year 1.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${vmc:annualRealizedBenefit,id=[vmcid]}${vmc:annualRealizedBenefit,id=123, year=1}${vmc:annualRealizedBenefit, id=123, scale=0.001, unit=k, dec=2}${vmc:annualRealizedBenefit, id=123, year=1, raw}
ValueMapCategoryAverageIdealTotalTag
The ValueMapCategoryAverageIdealTotalTag class is applied to
PowerPoint Report Templates when the following text is found in a text box:
${vmc:average_ideal_total, id=[vmcid]} where
[vmcid] is a valid value map category id. It will display the ideal
average total over the analysis period, text will be replaced in-line (as
opposed to removing and replacing the container).
Parameter id is required.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${vmc:average_ideal_total, id=[vmcid]}${vmc:average_ideal_total, id=123, scale=0.001, unit=k, dec=2}${vmc:average_ideal_total, id=123, raw}
ValueMapCategoryAverageRealizedTotalTag
The ValueMapCategoryAverageRealizedTotalTag class is applied to
PowerPoint Report Templates when the following text is found in a text box:
${vmc:average_realized_total, id=[vmcid]} where
[vmcid] is a valid value map category id. It will display the realized
average total over the analysis period, text will be replaced in-line (as
opposed to removing and replacing the container).
Parameter id is required.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${vmc:average_realized_total, id=[vmcid]}${vmc:average_realized_total, id=123, scale=0.001, unit=k, dec=2}${vmc:average_realized_total, id=123, raw}
ValueMapCategoryCurrentTotalTag
The ValueMapCategoryCurrentTotalTag class is applied to PowerPoint
Report Templates when the following text is found in a text box:
${vmc:current_total, id=[vmcid]} where
[vmcid] is a valid value map category id. It will display the current
total in-line (as opposed to removing and replacing the container).
Parameter id is required.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${vmc:current_total, id=[vmcid]}${vmc:current_total, id=123, scale=0.001, unit=k, dec=2}${vmc:current_total, id=123, raw}
ValueMapCategoryIdealBenefitTotalTag
The ValueMapCategoryIdealBenefitTotalTag class is applied to
PowerPoint Report Templates when the following text is found in a text box:
${vmc:ideal_Benefit_total, id=[vmcid]} where
[vmcid] is a valid value map category id. It will display the
ideal benefit total in-line (as opposed to removing and replacing the container).
Parameter id is required.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${vmc:ideal_Benefit_total, id=[vmcid]}${vmc:ideal_Benefit_total, id=123, scale=0.001, unit=k, dec=2}${vmc:ideal_Benefit_total, id=123, raw}
ValueMapCategoryIncludedTag
The ValueMapCategoryIncludedTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${vmc:included, id=[vmcid]} where it will return true if a category
was included.
[vmcid] is a valid value map category id. It will display in-line (as
opposed to removing and replacing the container).
Parameter id is required.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${vmc:included, id=[vmcid]}
ValueMapCategoryMultiYearTableTag
The ValueMapCategoryMultiYearTableTag class is applied to PowerPoint
Report Templates when the following text is found in a text box:
${vmc:table_multi_year} where
table_multi_year will return a Multi year summary of Value map
categories.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter headerFg will set the foreground color of the table header to the entered Hex value.
Optional parameter headerBg will set the background color of the table header to the entered Hex value.
Optional parameter textForeGround will set the foreground color of the table rows to the entered Hex value.
Optional parameter textBackground will set the background color of the table rows to the entered Hex value.
Optional parameter subTotalFg will set the foreground color of the table subtotal rows to the entered Hex value.
Optional parameter subTotalBg will set the background color of the table subtotal rows to the entered Hex value.
Optional parameter totalFg will set the foreground color of the table total rows to the entered Hex value.
Optional parameter totalBg will set the background color of the table total rows to the entered Hex value.
Optional parameter theme will set a default background color and text color for all rows (colors overwritten by above options). Accepts the following values:
- light
- dark
Optional parameter impactType will set the values returned. Accepts the following
- realized
- ideal
Optional parameter sortBy will set the order returned. Accepts the following
- default - default display order as presented on the Benefit scope page
- name - by name order
- value - by highest value
Optional parameter type determines the type of table returned. Accepts the following values:
- category (summary of a specific category, requires an id of the value category)
- monetary (summary of only monetary categories)
- non_monetary (summary of only non monetary categories)
- overview (brief overview of both monetary/non monetary categories)
This parameter is required if targeting a specific value category.
parameter id the id number of the value map category.
The tag is case-insensitive.
See ReportTag for syntax.
Examples:
${vmc:table_multi_year, projection=Conservative}${vmc:table_multi_year, type=overview}${vmc:table_multi_year, type=monetary, headerFg=#E0E0E0, headerBg=#11a6c0}${vmc:table_multi_year, type=category, id=1}${vmc:table_multi_year, type=category, id=1, theme=dark}
ValueMapCategoryNameTag
The ValueMapCategoryNameTag class is applied to PowerPoint Report
Templates when the following text is found in a text box:
${vmc:name,id=[vmcid]} where [vmcid] is a
valid value map category id. It will display the value map category name
inline (as opposed to removing and replacing the container).
Parameter id is required. There are no optional parameters.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${vmc:name,id=[vmcid]}${vmc:name,id=123}
ValueMapCategoryProposedTotalTag
The ValueMapCategoryProposedTotalTag class is applied to PowerPoint
Report Templates when the following text is found in a text box:
${vmc:proposed_total, id=[vmcid]} where
[vmcid] is a valid value map category id. It will display the proposed
total in-line (as opposed to removing and replacing the container).
Parameter id is required.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${vmc:proposed_total, id=[vmcid]}${vmc:proposed_total, id=123, scale=0.001, unit=k, dec=2}${vmc:proposed_total, id=123, raw}
ValueMapCategoryRealizedBenefitTotalTag
The ValueMapCategoryIdealBenefitTotalTag class is applied to
PowerPoint Report Templates when the following text is found in a text box:
${vmc:realized_Benefit_total, id=[vmcid]} where
[vmcid] is a valid value map category id. It will display the realized
benefit total in-line (as opposed to removing and replacing the container).
Parameter id is required.
Optional parameter scale where the decimal value passed will be used to scale the displayed value
Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)
Optional parameter dec where the value set will overwrite the decimal precision of the displayed value
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter raw when present will return the value with no formatting. If Currency the value will be returned in USD with no symbol. Commonly meant to be used in conjuction with evaluate tags.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${vmc:realized_Benefit_total, id=[vmcid]}${vmc:realized_Benefit_total, id=123, scale=0.001, unit=k, dec=2}${vmc:realized_Benefit_total, id=123, raw}
ValueMapCategoryValueTableTag
The ValueMapCategoryValueTableTag class is applied to PowerPoint
Report Templates when the following text is found in a text box:
${vmc:table_category_value} where
table_category_value will return various value summaries for Value map
categories, or various detailed summaries of a specific category.
Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection
Optional parameter sortBy will set the order returned. Accepts the following
- default - default display order as presented on the Benefit scope page
- name - by name order
- value - by highest value
Optional parameter headerFg will set the foreground color of the table header to the entered Hex value.
Optional parameter headerBg will set the background color of the table header to the entered Hex value.
Optional parameter textForeGround will set the foreground color of the table rows to the entered Hex value.
Optional parameter textBackground will set the background color of the table rows to the entered Hex value.
Optional parameter subTotalFg will set the foreground color of the table subtotal rows to the entered Hex value.
Optional parameter subTotalBg will set the background color of the table subtotal rows to the entered Hex value.
Optional parameter totalFg will set the foreground color of the table total rows to the entered Hex value.
Optional parameter totalBg will set the background color of the table total rows to the entered Hex value.
Optional parameter theme will set a default background color and text color for all rows (colors overwritten by above options). Accepts the following values:
- light
- dark
Optional parameter type determines the type of table returned. Accepts the following values:
- annual_ideal (annual ideal value summary)
- annual_realized (annual realized value summary)
- average_ideal (average ideal value summary of all years)
- average_realized (average realized value summary of all years)
- total_ideal (total ideal value summary of all years)
- total_realized (total realized value summary of all years)
This parameter is required if targeting a specific value category.
parameter id the id number of the value map category.
The tag is case-insensitive.
See ReportTag for syntax.
Examples:
${vmc:table_category_value, projection=Conservative}${vmc:table_category_value, type=annual_ideal}${vmc:table_category_value, type=average_ideal, headerFg=#E0E0E0, headerBg=#11a6c0}${vmc:table_category_value, type=average_realized, id=1}${vmc:table_category_value, type=total_realized, theme=dark}
ValueMapCategoryVisibilityTag
The ValueMapCategoryVisibilityTag class is applied to Report
Templates when the following text is found in a text box:
${vmc:visibility, id=[vmcid]} where it will return true if a category
was visible.
[vmcid] is a valid value map category id. It will display in-line (as
opposed to removing and replacing the container).
Parameter id is required.
The tag is case-insensitive.
See ReportTag for syntax.
Example:
${vmc:visibility, id=[vmcid]}${vmc:visibility, id=123}