formatting to respected currency (not all that are available as basic excel formats are available in windward)
we do business in 3 region and use different mode of currency payments such as USD, GBP, EUR and AED.
when building templates with relevant information that goes to finance teams for analysis i used windward(autotag) in excel linked to my SQL database. i have to created templates that are currency specific i.e. if the product was sold in GBP i have to produce all sales and expenditures towards the product in their respected GBP currency. (e.g. £1,100.56)
i have noticed that AED is not a current format that windward allows me to convert the figure too. however this feature is currently available as part of excel basic formatting.
so when i use a If statements to display (AED1,100.56) this is not allowed as the format is not available and if custom format is used it still doesn't allow me to do so.
This idea has been reviewed internally but declined due to lack of votes. Additionally, the workaround commented before hopefully solves the problem! Thank you for your suggestion, and please submit any other ideas you have to improve the software.
I was experimenting with the currency formats to try and solve your problem and may have found you a solution.
First I learned that outputting Out tags and using the Excel built in Accounting formats worked, but only if my Out tag type was Number. This worked for me for USD, GBP, EUR, and AED.
I also was able to use the built in Report Designer USD, GBP, and EUR formats to get my output. for AED I came up with the following custom format that seems to work: _("AED"* #,##0.00_);_("AED"* #,##0.00);_("AED"* "-"??_);_(@_)
In the Format Data dialog under Custom try entering this format and see if this fixes your issue.
I also entered a feature request for us to support the same formats supported by Excel in our formatting dialog. I have started the review process for this feature request and will update you as it is reviewed.
- The Windward Team