Hi
I have some code with a sum at the end which works fine, I would like to add another calculation that shows the % of the totals
, Coalesce(Min(Case When Name = 'Group' Then [Count] End), 0) As [Group]
, Sum([Count]) As [Total]
I have tried
, Coalesce(Min(Case When Name = 'Group' Then [Count] End), 0) As [Group]
, [Total] * 100 as percentage
But it does not like the *. I have tried various ways but cannot get it to work, could someone advise the syntax on this please
Thanks
I have some code with a sum at the end which works fine, I would like to add another calculation that shows the % of the totals
, Coalesce(Min(Case When Name = 'Group' Then [Count] End), 0) As [Group]
, Sum([Count]) As [Total]
I have tried
, Coalesce(Min(Case When Name = 'Group' Then [Count] End), 0) As [Group]
, [Total] * 100 as percentage
But it does not like the *. I have tried various ways but cannot get it to work, could someone advise the syntax on this please
Thanks