Dimmension Problem

[pgalvezt]

Hello,

I'm doing an stratification by debt days within with percentages. 'Comercio' has a lot of client one of them needs to put all debt inside 'To Date' (Al Día).

I need this

Al día And 0% For Inp Customer.

The other Customer has to have all percentages.

This is my 1st Dimmension if(Comercio='Inp' or isnull(Comercio), 'Al Día', Descripcion)

This is my 2nd Dimmension If(Comercio= 'Inp',Num(Porc_Provision,'0%'))

I attached a picture that show the current result.

Thanks!

[pgalvezt]

Any Help?

Thanks!

[MayilVahanan · Accepted solution]

HI

From This , If(Comercio= 'Inp',Num(Porc_Provision,'0%'))

if comerico value is not inp, what to display is not mention? so only it display the '-' value, so please give the else part..

Hope it helps

[pgalvezt]

Nice. You're right I just to put the other part. Just one question my percentages appears like 0.01 0.1 0.2 and so on What function is better to left it like 1% 2% and so on.

Thanks!

[MayilVahanan]

HI

Try like this

Num( Sum(Sales),#.#0% )

or

In number tab, use fixed to 1 and tick the show in percent.

Both helps