CONCATENATE Bug Encountered:

[dev_bc]

Hi,

The dollar sign $ is missing on display. Is it this the bug for CONCATENATE?

[Lynn]

Hi @dev_bc It looks like your column is text, not Price. does that make any difference?

[dev_bc]

Hi Lynn,

Ya, is text. Can the dollar sign $ in text form? because this column tight with text condition.

[Lynn]

Not sure why that is not working for you.

[dev_bc]

Could be bug?

[Lynn]

Hi @dev_bc I just did some testing and it seems to work ok for me. My spreadsheet col is text and app col long text. The concat is including the $ sign ok.

[Aleksi]

@dev_bc I tested your formula as well and it’s working fine.

[dev_bc]

Dear @Lynn Lynn & @Aleksi

Ok, previous question the formula is apply at Actions (Data: set the value of a column).

Let’s try the basic. Now we try to see the result the formula is apply at own column (App formula). You can see the result when after edit the column data show correctly while app is loading. After loading is done the $ is gone.

The column type is Long Text.

If i try using Virtual Column. It work fine.

[Steve]

Try wrapping your expression with TEXT().

[dev_bc]

Hi @Steve

Now i change the data type for Saving Account and Withdraw to Text. It show the above error.

I think the error said that “Saving Account” is in text. Can’t do math formula

1. [Saving Account] > 49
2. [Saving Account] - 30

Is it this the try you wanted me to do?

[LeventK]

@dev_bc
If your [Saving Account] is text; then you shall make the evaluation like this:

IF(NUMBER([Saving Account]) > 49, CONCATENATE("$",NUMBER([Saving Acount])-30),"<$50")

[dev_bc]

Hi @LeventK

Actually the [Saving Account] is price. For testing advise by @Steve i change the type to Text.

After add the Number([Saving Account]) the error message is gone. But the result still the same

I found that if i add a apostrophe ( ’ ) before the dollar sign.
IF(NUMBER([Saving Account]) > 49, CONCATENATE("’$",NUMBER([Saving Account])-30), “<$50”)

Seems like this is work around method. In the spreadsheet it show the dollar sign just it can’t show in the app.

Please can you verify is it this the bug?

[LeventK]

@dev_bc
If your [Saving Account] is price type than you should construct the expression like this as @Steve had already proposed:

IF([Saving Account]) > 49, TEXT([Saving Acount]-30),"<$50")

This will do the trick

[dev_bc]

@LeventK

Ok, i change the [Saving Account] to price type.

Do you mean the code is
IF([Saving Account] > 49, TEXT(CONCATENATE("$",[Saving Account]-30)), “<$50”)

The dollar sign will gone after the loading is done.

[LeventK]

dev_bc:

@LeventK

Ok, i change the [Saving Account] to price type.

Do you mean the code is
IF([Saving Account] > 49, TEXT(CONCATENATE("$",[Saving Account]-30)), “<$50”)

The dollar sign will gone after the loading is done.

@dev_bc
Change your [Saving Account] column’s type back to Price and use below expression as I have given above:

IF([Saving Account] > 49, TEXT([Saving Acount]-30),"<$50")

[dev_bc]

@LeventK

Problem still remain the same. After loading the $ is gone.

[LeventK]

@dev_bc
Can you try with:

IF([Saving Account] > 49, CONCATENATE([Saving Acount]-30),"<$50")

[dev_bc]

@LeventK

IF([Saving Account] > 49, CONCATENATE([Saving Acount]-30),"<$50")

Following is the result:

In the edit page it didn’t show the $ as well.

This code can’t show the $ since at edit page.