johns
Design Dabbler

Create a field which has a currency symbol and an amount (with commas)

Jump to solution

Hi all, 

I have a very old SharePoint list which I want to update without breaking any of the existing functionality. 

There are 2 existing fields: 

1. A currency field (which is a choice - £/€) 

2. A string of a number up to 10000000 (without commas) 

 

What I would like to do is concatenate the currency choice and insert commas in to the resulting field. So for example: 

Existing fields : £ and a string of number - e.g. 10000 

What I want : £10,000 in a new field 

 

There is an underlying workflow so editing the fields will kick it off, which I don't want. I have managed to convert 10000 to 10,000 in a few field (using =VALUE([Request Amount])), but ideally I'd like to add in the currency at the start. 

 

Is this possible in SharePoint 2013? 

 

Thanks for you help, apologies I'm a SP newbie. 

0 Kudos
Reply
6 Replies
claudiaurbanski
Process Pupil

Re: Create a field which has a currency symbol and an amount (with commas)

Jump to solution

@johns This should be easy enough to accomplish:

 

Add  a calculated column  =CONCATENATE(Currencyfield,TEXT(Amountfield,"#,###"))

 

claudiaurbanski_0-1622811480100.png

 

0 Kudos
Reply
johns
Design Dabbler

Re: Create a field which has a currency symbol and an amount (with commas)

Jump to solution
Hi,
Thanks for your reply.
That is almost perfect, the only problem is it isn't converting when the currency field has a 0 in it. Any thoughts?
0 Kudos
Reply
claudiaurbanski
Process Pupil

Re: Create a field which has a currency symbol and an amount (with commas)

Jump to solution

@johns Can you provide an example? If currency choice field is 0 what should your calculated value be, just the amount?

0 Kudos
Reply
johns
Design Dabbler

Re: Create a field which has a currency symbol and an amount (with commas)

Jump to solution

Sorry - I should have been clearer. If the amount is 0 in the existing string field, I get just a currency sign in the new field. 

I'll try attach a pic. What I want is €0 instead of €. Otherwise, the solution is perfect. Thanks for your help. 

 Capture.PNG

0 Kudos
Reply
claudiaurbanski
Process Pupil

Re: Create a field which has a currency symbol and an amount (with commas)

Jump to solution

@johns Something like this should work.

 

=IF(Amountfield<>"0",CONCATENATE(Currencyfield,TEXT(Amount,"#,###")),CONCATENATE(Currencyfield,("0")))

 

claudiaurbanski_0-1622814837180.png

 

View solution in original post

0 Kudos
Reply
johns
Design Dabbler

Re: Create a field which has a currency symbol and an amount (with commas)

Jump to solution

Thanks for your help! Marked as solution!

0 Kudos
Reply