Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I have below expression that sits in a pivot table under dimensions.
Aggr(Round(Sum({<[Pdiv Id No]-={6,11,12}, [SK Plan Type No]={1}, [Season Description EP]={'Winter'}>}[Binc Sale Sell Amt])), Division, Department).
This is returning the number format of 123456789.
I would like the above expresion to return 123 456 789.
How am I able to achieve that?
Hi
Try like below
=Num(Aggr(Round(Sum({<[Pdiv Id No]-={6,11,12}, [SK Plan Type No]={1}, [Season Description EP]={'Winter'}>}[Binc Sale Sell Amt])), Division, Department), '# ##0','.', ' ')
HI
Try like below
Num(Aggr(Round(Sum({<[Pdiv Id No]-={6,11,12}, [SK Plan Type No]={1}, [Season Description EP]={'Winter'}>}[Binc Sale Sell Amt])), Division, Department),'# ###')
Hi
It's returning 1e+07 ###
Hi
Try like below
=Num(Aggr(Round(Sum({<[Pdiv Id No]-={6,11,12}, [SK Plan Type No]={1}, [Season Description EP]={'Winter'}>}[Binc Sale Sell Amt])), Division, Department), '# ##0','.', ' ')
Hi
This is giving expected result, thanks.