I am trying to format a sum expression, then pass the results to powerpint.
the experession i have the the field cell is this:
newtotal: Sum (Format([bets].[total1]-[bets].[leaders].[total],("£#,##0;(£#'##0)")))
Inorder to display corectly in powerpoint, It needs to display the "£" without the field propities selected to currency.
Is it posable to use "totalnew" in a groupby formatted experssion?
the experession i have the the field cell is this:
newtotal: Sum (Format([bets].[total1]-[bets].[leaders].[total],("£#,##0;(£#'##0)")))
Inorder to display corectly in powerpoint, It needs to display the "£" without the field propities selected to currency.
Is it posable to use "totalnew" in a groupby formatted experssion?
