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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (30,372)