Navigate
Wasp Helpdesk
  • Register

  • or
  • Login
    Need a password reminder?
or
Contact Us
  • Get in touch

    Send us an email

  • Start a chat session

  • Knowledgebase Read help articles
  • News News & updates
  • Contact Us We are here to help
  • Training View our options
  • Product Sunsets Non-Supported Products
Barcode System Consult
Barcode Printer Consult
Barcode Label Consult
  • Portal
  • Knowledgebase
  • Cloud
  • Cloud Reports: Trying to use string.Format(FormatMoneyDecimal but FormatMoneyDecimal doesn't exist as a variable in the report
Subscribe Download PDF

Cloud Reports: Trying to use string.Format(FormatMoneyDecimal but FormatMoneyDecimal doesn't exist as a variable in the report

Scott Leonard
2023-06-02
in Cloud

Some of the Cloud reports contain a variable called FormatMoneyDecimal, which allows you to format a monetary field (e.g. cost) using the monetary decimal place value in Cloud settings.

However, some reports do not have FormatMoneyDecimal, and if you try to use it, there is an error when you run the report: "The name 'FormatMonetaryDecimal' does not exist in the current context." Here's how to add it to the report in the Report Designer.

At bottom left, click Dictionary tab.
Expand out Variables, Do Not Touch.
Right-click Do Not Touch, then New Variable.

Name: FormatMoneyDecimal
tab key, Alias changes to FormatMoneyDecimal
Type: string, Value
Init by: Expression
Expression: "{0:N" + MonetaryDecimalPlaces +"}"

OK

upload.png

Rate the quality of this page

This page was helpful :) :( This page was not helpful

Related Pages

  • InventoryCloud report customization: Pick Order Details Report - line totals, Pick order total
  • AssetCloud & InventoryCloud Report Customization List
  • InventoryCloud report customization: Purchase Order Details Report - line totals, report grand total
  • AssetCloud & InventoryCloud: Reports with monetary totals show unexpected values
  • InventoryCloud Report editing example: Add a grand total to the Inventory Cost Report

Quick Jump
  • Wasp Helpdesk
  • Knowledgebase
  • News
  • Contact Us
Top
Helpdesk software provided by Deskpro