Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all. i have a problem in pivot table.
See image i atach,
thanks in adavance.
anyone can tell me somthing?
Hi,
Can you send an example file or what is the expression?
BR
Ariel
The expression is:
num(BILLLINES.VATTAX/100,FormatoNumPorcen)
Varible FormatoNumPorcen= #.##0%
Regards.
Hi,
Try
num(Sum(BILLLINES.VATTAX)/100,FormatoNumPorcen)
BR
Ariel
Not work, see image.
thanks.
hi,
Try
num(Avg(BILLLINES.VATTAX)/100,FormatoNumPorcen)
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.
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%'
Still not working, thanks for all answerd!!
Atach an image!!
Regards