Subtracting latest month from prior month value

[GDunn1]

I want to create a sum to minus the latest month from the prior month. Then change the answer to the millions number format. This expression does not cause an error, but does return 0 values;

num (sum( {<MonthKey={'$(=max(MonthKey)))'} >}ClosingFUA ) - (sum( {<MonthKey={'$(=max(MonthKey)-1))'} >}ClosingFUA )) /1000000, '#,##0.00 M')

[Lisa_P]

Your expression has too many closing brackets ..

num (sum( {<MonthKey={'$(=max(MonthKey)))'} >}ClosingFUA ) - (sum( {<MonthKey={'$(=max(MonthKey)-1))'} >}ClosingFUA )) /1000000, '#,##0.00 M')

[GDunn1]

Thanks @Lisa_P , removing these brackets returns the value but the number format is the full number and M (12,345,678.90 M) rather than the 12.3 M format required.

[Lisa_P]

Ok, try this:

num (
              (sum( {<MonthKey={'$(=max(MonthKey)))'} >}ClosingFUA )
               - sum( {<MonthKey={'$(=max(MonthKey)-1))'} >}ClosingFUA ))
               /1000000
          , '#,##0.0 M')

[GDunn1]

Thanks @Lisa_P , but this returns zero for each line item

[Lisa_P · Accepted solution]

Sorry, I didn't remove the extra brackets ..

num (
              (sum( {<MonthKey={'$(=max(MonthKey))'} >}ClosingFUA )
               - sum( {<MonthKey={'$(=max(MonthKey)-1)'} >}ClosingFUA ))
               /1000000
          , '#,##0.0 M')

[GDunn1]

Excellent, thank you @Lisa_P . Perfect