Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi and thanks for tahks for the attentions.
i have this problem, in a dimension i should calculated progress disregarding all selections but not dimension.
to semplify the question my problem is:
why this formula considering the selection?
=sum({1}aggr(nodistinct WEIGHT,PROJECT_NAME,WBS_NAME,TF_NAME,INT_TF_NAME,DISC_NAME,INT_DISC_NAME,EMC_NAME,INT_EMC_NAME,ACTIVITY_NAME,JOB_DOC_ID))
if no selections formula gives the correct sum weight of a documents but if I filter one document returns the weight of the document selected also I use {1} in sum function
Many thanks,
Kinney
Try: =sum({1}aggr(nodistinct only({1} WEIGHT), PROJECT_NAME, WBS_NAME, TF_NAME, INT_TF_NAME, DISC_NAME, INT_DISC_NAME, EMC_NAME, INT_EMC_NAME, ACTIVITY_NAME, JOB_DOC_ID))
many thanks,i'll try to work with only function.