Percentage and Numbers

[Sussan]

Hi,

I am very new to PowerApps so i have some very basic questions: how can I add comma or point between my numbers here (in my SharePoint list it shows correctly): 

This is my current formula for this: LookUp('Site-Target',ID=8,Target)

And how do I add percentage icon after the number represented here: 

Text entry: Slider1.Value%

Thanks,

Su

[jcfDaniel · Accepted solution]

Hi,

For the percentage: Slider1.Value & "%"

[NandiniBhagya20]

Hi @Sussan ,

You can use Text function. Below is an example of comma and dot:
Text("12000", "#,###") => 12, 000
Text("12,000","#,###.00") => 12,000.00

[jcfDaniel · Accepted solution]

For the formating of the target, try tihs:

Text( Value(LookUp('Site-Target',ID=8,Target)), "#,###")

[Sussan]

Thank you very much!