Formula Help

[PBrainNWH]

I want to change the value in one column to a negative number if the value of another column starts with SC-

[ichavarria · Accepted solution]

Hi @PBrainNWH,

It is difficult to provide an answer to these question without additional data to better understand the data and the desired outcome.

1. What is the name of the column that you want to change the value to a negative number?
2. What is the name of the column that you are checking for values starting with "SC-"?
3. What is the data type of the columns that you are working with?
4. Can you provide an example of the data that you are working with?
5. Do you want to replace the existing value in the column with a negative number, or do you want to create a new column with the negative value?
6. Should the negative value be the same as the original value, but with a negative sign, or should it be a different value?
7. Do you want the changes to be applied only in the report or do you want to modify the underlying data as well?

Best regards, 

Isaac Chavarria

If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quickly.