
Hi Everyone,
Good day!
I have a variable contain number named varRndB1BSIRow and I want it to concatenate with "$" symbol.
However nothing happens using my code below:
" $ " & Text(varRndB1BSIRow, "[$-en-US]###,###,###")I also tried :
Text(varRndB1BSIRow, "[$-en-US]$###,###,###")
Still doesn't work.
But in some areas it's working. can you help and explain why?
@YamiteKudasai
Try this
If(
IsBlank(varRndB1BSIRow) || IsBlank(Text(varRndB1BSIRow)),
Notify("It is blank", NotificationType.Error),
"$" & Text(varRndB1BSIRow, "[$-en-US]###,###,###")
)
If you see "it is blank" red message at the top, then it's because of the variable being blank sometimes.
You may want to check on the variable and see why it is sometimes blank, by exiting preview mode and then mousing over the varRndB1BsIRow in the formula bar once you get the red message.
See if it helps @YamiteKudasai