Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all..
need help regarding expression. i am using the below expression
sum(aggr(if(max(VERSION_NUMBER)=MAX_VERSION_NUMBER,
sum(aggr(
(Sum((if((vDebtors-[Invoice GL Date]) >=0,[EXTENDED_AMOUNT])))
)
*(if(max(VERSION_NUMBER)=MAX_VERSION_NUMBER,PERCENTAGE_ALLOCATED/100)),PERCENTAGE_ALLOCATED,PORTFOLIO_MEMBER_NAME,[Project ID]))
-
sum(aggr(
(Sum(if(APPLY_DATE<=vDebtors,AMOUNT_APPLIED)))
*(if(max(VERSION_NUMBER)=MAX_VERSION_NUMBER,PERCENTAGE_ALLOCATED/100)),PERCENTAGE_ALLOCATED,PORTFOLIO_MEMBER_NAME,[Project ID]))
+
sum(aggr(
(Sum(if(GL_DATE<=vDebtors,ACCTD_AMOUNT)))
*(if(max(VERSION_NUMBER)=MAX_VERSION_NUMBER,PERCENTAGE_ALLOCATED/100)),PERCENTAGE_ALLOCATED,PORTFOLIO_MEMBER_NAME,[Project ID]))
)
,PERCENTAGE_ALLOCATED,PORTFOLIO_MEMBER_NAME,[Project ID]))
i think there is sme error with this expression.since it is taking too long to reload thought the values are comin correctly.
Hi.
I have created expressions :1.Sum(order total)
2.Max(order total)
3.Max(Aggr (Sum([order total],[customer name],[employee Id]))
4.Firstsorted values([customername], - Aggr(sum([order total]),[customername],[employeeId]))
if use ASC order and DES(-)
try your expression .
Thanks,
sreenu
hi,
thanks for your reply..
bt i didnt get wat yu exactly mean..how can it be dne with my expressions?
Hi Reena,
Try to push much of the calculation to script so that it will not take much of the time calculating in the front end.
yea...bt these fields are comin frm different tables tht i am nt able to do it in script..
making joins can help you bringing the fields from different tables into a single tables off-course that will increase load time but it is your choice if your users want to keep waiting for this calculations to happen or let your server do and keep data ready for the users.
I personally think users are generally with much lesser RAM and we should push this calcs back in script so that server with its bigger RAM can processes this and keep it ready
Hi Reena,
Can u provide what tables u have in data model ...?