Power query Data type

[dicken]

Hi,
I have the following in a group;

 { "Percent", each  List.Sum( [Units] ) / List.Sum(Source [Units]) }} )

and I'd like to add the data type percentage.type., but can't figure out where it should go, or do I have to wrap the whole thing in Listtranformcolumntypes?

RD

 

[RoryA]

You should be able to use:

{ "Percent", each List.Sum( [Units] ) / List.Sum(Source [Units]), Percentage.Type}})

 

[dicken]

You should be able to use:

{ "Percent", each List.Sum( [Units] ) / List.Sum(Source [Units]), Percentage.Type}})

I thought I'd tried that already, but I may have slipped up.
I'll take it you're right and mark this up.

RD