Problem show in pivot table.

[fdelacal]

HI all. i have a problem in pivot table.

See image i atach,

thanks in adavance.

[fdelacal]

anyone can tell me somthing?

[ariel_klien]

Hi,

Can you send an example file or what is the expression?

BR

Ariel

[fdelacal]

The expression is:

num(BILLLINES.VATTAX/100,FormatoNumPorcen)

Varible FormatoNumPorcen= #.##0%

Regards.

[ariel_klien]

Hi,

Try

num(Sum(BILLLINES.VATTAX)/100,FormatoNumPorcen)

BR

Ariel

[fdelacal]

Not work, see image.

thanks.

[ariel_klien]

hi,

Try

num(Avg(BILLLINES.VATTAX)/100,FormatoNumPorcen)

[fdelacal]

Ariel Klien thanks again but still not working.

er.mohit  look better solution but not work too.. i atach an image that you can see the result.

Regards.

[#9]

TRY THIS

num((BILLLINES.VATTAX/sum(total BILLLINES.VATTAX)),'##00%')

WHERE  VARIABLE NAME IS

FormatoNumPorcen='##00%'

******************************************

OR TRY THIS

num((

sum(DISTINCT BILLLINES.VATTAX)/sum(total BILLLINES.VATTAX)),'##00%')

WHERE  VARIABLE NAME IS

FormatoNumPorcen='##00%'

[fdelacal]

Still not working, thanks for all answerd!!

Atach an image!!

Regards