cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pyrlo28
New Member

Field Calculation displayed in Currency

Hello,

 

I have a following App. A user input number in Quantity and month fields then receive the amount needed for spending.

 

pyrlo28_0-1663654699794.png

 

I would like to have the Monthly Cost price so Button1_1.Text displayed in  as well as the Total cost which is calculated using below formula. 

 

 

 

<< Quantity * Monthly Cost * Calculate cost for below number of months >>

Value(TextInput1.Text) * Value(Button1.Text) * Value(TextInput1_8.Text)+
Value(TextInput1_1.Text) * Value(Button1_1.Text) * Value(TextInput1_8.Text)+
Value(TextInput1_2.Text) * Value(Button1_2.Text) * Value(TextInput1_8.Text)+
Value(TextInput1_3.Text) * Value(Button1_3.Text) * Value(TextInput1_8.Text)+
Value(TextInput1_4.Text) * Value(Button1_8.Text) * Value(TextInput1_8.Text)+
Value(TextInput1_6.Text) * Value(Button1_12.Text) * Value(TextInput1_8.Text)+
Value(TextInput1_7.Text) * Value(Button1_14.Text) * Value(TextInput1_8.Text)+
Value(TextInput1_5.Text) * Value(Button1_10.Text) * Value(TextInput1_8.Text)+
Value(TextInput1_9.Text) * Value(Button1_21.Text) * Value(TextInput1_8.Text)+
Value(TextInput1_10.Text) * Value(Button1_23.Text) * Value(TextInput1_8.Text)+
Value(TextInput1_12.Text) * Value(Button1_27.Text) * Value(TextInput1_8.Text)+
Value(TextInput1_13.Text) * Value(Button1_29.Text) * Value(TextInput1_8.Text)

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @pyrlo28 ,

 

You could set the button's text property to 

Text(109.333,"€0.00")

 and get the sum value by

Value(TextInput1.Text) * Value(Substitute(Button1.Text"€","")) * Value(TextInput1_8.Text)+
.
.
.

 

Best Regards,

Bof

View solution in original post

1 REPLY 1
v-bofeng-msft
Community Support
Community Support

Hi @pyrlo28 ,

 

You could set the button's text property to 

Text(109.333,"€0.00")

 and get the sum value by

Value(TextInput1.Text) * Value(Substitute(Button1.Text"€","")) * Value(TextInput1_8.Text)+
.
.
.

 

Best Regards,

Bof

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,704)