$ SIGN ISSUE

Rohit Kulkarni 731

Hello Team,

I want to do the sum and sub for the particular mentioned below in the screenshot. Please advise the formula How to remove the $ sign.

Regards
Rk

ShaikMaheer-MSFT 38,631 Reputation points Microsoft Employee Moderator

2021-11-09T11:11:43.81+00:00

Hi @Rohit Kulkarni ,

Just checking in to see if the below answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.
ShaikMaheer-MSFT 38,631 Reputation points Microsoft Employee Moderator

2021-11-11T12:07:39.837+00:00

Hi @Rohit Kulkarni ,

Following to see if the below answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.

2 answers

Nasreen Akter 10,896 Reputation points Volunteer Moderator

2021-11-01T15:40:05.63+00:00
Hi @Rohit Kulkarni ,

Would you please try the following:

toDecimal(colName, 9, 2, '$#######.##') toDecimal(colName1, 9, 2, '$#######.##') + toDecimal(colName2, 9, 2, '$#######.##')

Thanks!
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
MarkKromer-MSFT 5,231 Reputation points Microsoft Employee Moderator

2021-11-01T20:35:58.337+00:00

dropLeft(colname,instr(colname','$'))
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer