Is it possible to add a "+" symbol in front of positive values?

Waleed Ullah · September 2023

Using the image above as an example, is it possible to add a "+" value in front of the 89.0% without writing it as an text algorithm in the data view? (as this is requested in multiple views)

I understand it's possible to add a prefix in block formatting however that wouldn't recognise a value as <>0 so it would place a"+" in front of the negative values too e.g. "+-12.3%"

Thanks!

Willians Santana · September 2023

Hi, Waleed,

I hope you are having a great day!

Thank you for your question! I do appreciate that.

Please let me know if the "Symbol before" or "Symbol after" options work for you according to the Board Manual link below:

https://www.boardmanual.com/2021/summer/data-modeling/2_Database_design_functions/13_Format/format.htm?rhsearch=symbol%20before&rhhlterm=symbol%20before

Best Regards,

Willians

Waleed Ullah · September 2023

Hi @Willians Santana

I hope you're doing well!

Thank you for your quick response!

Unfortunately, that function won't always perform as I'd want it to. If I were to add a "+" in the "Symbol before", it wouldn't recognise a negative value, so it'd add this "+" in this case too (as explained in my example in the original post).

Thanks,

Waleed

Willians Santana · September 2023

Thank you for your confirmation and clarification, Waleed! I do appreciate that.

Please let me review it. I will respond to you as quickly as I can.

Waleed Ullah · September 2023

@Willians Santana Thank you!

Bettina Clausen · September 2023

Hi,

there is no other way to integrate a "+" than using a concatenated text block.
If you need to include thousands-separator you might want to use Nexel as a workaround. However, I would try to avoid this.

Kind regards,
Bettina