cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sajarac
Kudo Kingpin
Kudo Kingpin

Decimal format for a summing field

Hi there, could tyou please let me know how to apply a decimal and currency format for my fileds located outside of my gallery?

 

In those fields I am getting a sum of the gallery items.

 

See screenshot

 

Thanks in advance

 

Regards

 

Capture.PNG

2 ACCEPTED SOLUTIONS

Accepted Solutions
Meneghino
Community Champion
Community Champion

Hi again @sajarac

You just need to wrap around the sum the same formatting function that you have in the gallery labels.

So:

Text(Sum(Gallery4.AllItems,TSqFt),"#,##0.00")

View solution in original post

Meneghino
Community Champion
Community Champion

The answer is still the same:

Text(Sum(Filter(MainQuery,FiscalYear = drpfy.Selected.Value),SquareFootage),"#,##0.00")

View solution in original post

4 REPLIES 4
Meneghino
Community Champion
Community Champion

Hi again @sajarac

You just need to wrap around the sum the same formatting function that you have in the gallery labels.

So:

Text(Sum(Gallery4.AllItems,TSqFt),"#,##0.00")

View solution in original post

Thank you very much for your prompt reply, I've tried several choices and none of them works!!

 

Regards

Hi there, sorry to bother you again, I have another field, and for some reason I cannot get the decimal and the currency format, could you please help me out?

 

Label:

Sum(Filter(MainQuery,FiscalYear = drpfy.Selected.Value),SquareFootage)

 

Thanks in advance for any response,

 

Regards

Meneghino
Community Champion
Community Champion

The answer is still the same:

Text(Sum(Filter(MainQuery,FiscalYear = drpfy.Selected.Value),SquareFootage),"#,##0.00")

View solution in original post

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (65,055)