Hey,
I am creating an Invoice app where I need to create invoices in USD ($) and INR, how can I have multi currency setup in my price column, I know we can concentate the currency symbol as the prefix but thats not what I want to do
Please help.
Regards
Rajiv
@rajivvaishnav I would suggest not using the price column, but rather decimal and then on the invoicing table put a column enum with your own currencies, assign the currency each time to the order or invoice, etc.
You can concatenate the currency symbol and the decimal value together for your views as a label of Price..
This allows you to do things like group by currency and also create slices for views for each currency stats. Etc..
Hey Thank you for such a quick reponse, I tried, but my amount field is a calculated formula which is this :
SUM(SELECT(Line Items[Total], [invoice_id] = [_THISROW].[invoice_id]))
and I tried this “$”&SUM(SELECT(Line Items[Total], [invoice_id] = [_THISROW].[invoice_id]))
But its not working since decimal is a numeric field and I am adding text to numeric which is not working, any workaround?
Leave your calculations as is decimal without adding anything and then create a Seperate Virtual column as text type, then add the currency symbol and the calculated column together in that step?
VC column name: “Amount Label”
Formulae = [Currency] & " " & [Amount]