Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have below mention expression and I want to convert to aggregation expression, reason behind converting into aggregration expression because I have multiple dimention and in each dimention I want total but with below mention expression it is limted to only VOUCHERNO.
I have below mention dimention on my piovt chart :
BRANCH_CODE,
YEAR,
QUARTER,
MONTH,
ITEMTYPE,
VOCHERDATE ,
VOCHERNO,
STOCKCATEGORY,
STOCKCODE
-------------------------------------------------------------------------
(
(sum(DISCOUNTCC))
*
(
(sum(SALESPRICE))
/
(sum(TOTAL<VOCHERNO>SALESPRICE))
*100
)
/100
)
--------------------------------------------------------------------------
I had tried to below mention expression but i did not get any result but not sure why
-------------------------------------------------------------------------
aggr(
(sum(DISCOUNTCC))
*
(
(sum(SALESPRICE))
/
(sum(TOTAL<VOCHERNO>SALESPRICE))
*100
)
/100
,BRANCH_CODE,YEAR,QUARTER,MONTH,ITEMTYPE,VOCHERDATE,VOCHERNO,STOCKCATEGORY,STOCKCODE
)
--------------------------------------------------------------------------
So any idea why ?
Is anyone ready to help me on my question ?
Can you provide a sample? And clearly describe the output you require.
Hi,
Try this expression
Sum(
aggr(
(sum(DISCOUNTCC))
*
(
(sum(SALESPRICE))
/
(sum(TOTAL<VOCHERNO>SALESPRICE))
*100
)
/100
,BRANCH_CODE,YEAR,QUARTER,MONTH,ITEMTYPE,VOCHERDATE,VOCHERNO,STOCKCATEGORY,STOCKCODE
))
Hope this helps you.
Regards,
Jagan.
Thanks Jagan mohan,
it is all most same answer I am looking for.
After trying above mention expression I had found that when I am exploring and reaching to individual item calculation is correct but when I am closing one by one dimension total is getting reduce.
I will prepare example from real data and post here so you guys and understand the issue.
Appreciate your time and cooperation.
I had post reply on jagan post and sure I will prepare sameple data from real data and post here.
Thanks.
Hi,
Try this expression
Sum( TOTAL <BRANCH_CODE,YEAR,QUARTER,MONTH,ITEMTYPE,VOCHERDATE,VOCHERNO,STOCKCATEGORY,STOCKCODE>
(sum(DISCOUNTCC))
*
(
(sum(SALESPRICE))
/
(sum(TOTAL<VOCHERNO>SALESPRICE))
*100
)
/100)
Hope this helps you.
Regards,
Jagan.