Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a condition for given straight tables of around 6k records. it's taking so much time to load.
i have multiple if condition like eg:
if getselected count(field)=1, sumx,
if getselected count(field)=2, sumy+sumX,
if getselected count(field)=3, sumz+sumy+sumX
so the straight table is loading slow
instead of that i want to give
condition in general i.e calculation condition ,
conditional enabling in expression ,
condition in layout
which is good for better performance....if not is there any good solution to optimize staright table
plz help
Thanks
have a Great day
See if you can move this condition to your scripting level. That will be the optimum option.
-RV
Thanks Rajesh for your response,
the expression i'm using is not straight forword, it actualy something like this
= (set exp1/set exp2)/set exp3/set exp4)
so i think that something not possible to bring from scrpiting .
Any other suggestions will be much appricated
why dont u create variables for differnt variables
if getselected count(field)=1, sumx, as variable 1
if getselected count(field)=2, sumy+sumX,as variable 2
if getselected count(field)=3, sumz+sumy+sumX as variable 3
and then use an if condition .. that may help u
Thanks For the reply Shree,
what i'm thinking is 3 object with each condition in layout like getselected count(field)=1
getselected count(field)=2, for another object
getselected count(field)=3, for another object
and give direct expression in expresion tab..
in the above case calculation happens only once ie. get secleted calculation and followed by sum
as you said , if i give them in variable , for each values of dimension it should calculates the variable + if condition
for the variables...so I feel it takes more calculation time .correct me if i'm wrong 😮
Thanks once again
Hi,
This might work for you i think.Check it
Pick(getselected count(field),sumx,sumy+sumX, sumz+sumy+sumX);
Hope this helps
Thanks for the reply Celambarasan, it helps me
and let me add something to it
I have condition like
get slected count(field1)>0,exp1
get slected count(field2)>0,exp2
get slected count(field1) and get slected count(field2)>0,exp3
in this case which option is better i'm thinking of going to have 3 objects with each diff condition in layout