convert sum of grouped values to currency

[Kgray15]

Good day PA community,

I have what I hope to be a pretty simple question with a simple solution.  I have built an application that is grouping a number of records from an SQL DB.  I need several amounts from that DB and convert them to currency.  This is functional in other parts of my app but I cannot seem to get it to work when multiple records have been grouped.  See the screenshots below.  The first is where it is not working as intended on a grouped value. The second where it is on an ungrouped value.  

I think it may have something to do with the fact that the values are no longer recognized as numbers once they are grouped but I'm not really sure.

Any insight would be greatly appreciated.

[RandyHayes]

@Kgray15 

You're actually missing the Text function on your formula.

I believe you want Text(Sum(ThisItem.Batches, PremiumAmount), "$#,###,##0.00")

I hope this is helpful for you.

[Kgray15]

Hey @RandyHayes , I've tried that as well. Still no luck unfortunately.

[RandyHayes · Accepted solution]

@Kgray15 

I'm not sure why you are using the Value function in there.  If those amounts are numbers, there is not a need.

[Kgray15]

@RandyHayes, Looks like that alone solved it. Removed the value function and it's working just fine.

I had read somewhere that once you use the GroupBy function, number values are considered text.  I was trying to convert it back to a number using the Value function but that was clearly not required.

Text(Sum(ThisItem.Batches,PremiumAmount), "[$-en-US]$###,####.00") works.

[RandyHayes]

Good deal.  

No, grouping does not change data types.  If they are numbers they will be numbers.

Glad to help.