Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Im doing a sum of some accounts (P&L accounts) that give me the net sales, the problem i have is that i have to use the "total" because if i dont put it i have zero, also i have to specify the period because if i dont i have the sum of all the periods in the line.
here is the code im using
IF([P&L ACCOUNTS]='TOTAL NET SALES',
Sum(total{<[Period]={'151P'},[P&L ACCOUNTS]={'NET SALES'}>}Amount/1000),
sum(Amount)
)
can anyone help me please!
Try this
If([P&L ACCOUNTS] = 'TOTAL NET SALES',
Sum(TOTAL <Period>{<[P&L ACCOUNTS] = {'NET SALES'}>} Amount/1000),
Sum(Amount)
)
Try this
If([P&L ACCOUNTS] = 'TOTAL NET SALES',
Sum(TOTAL <Period>{<[P&L ACCOUNTS] = {'NET SALES'}>} Amount/1000),
Sum(Amount)
)
Thank you!!! it works