Text object expression.

[#1]

Hi,

I am using the following expression (TEXT OBJECT):

=NUM(((sum(T_NST_CD_OUTQTY1_DAY_RW)/T_NST_ELAPSED_DAYS)/AVG(AGGR(SUM

(T_MERRTE_STEP_COUNT),T_NST_DEVICE)))*T_NST_MAXMONTHDAYS,'###,##0')

I want to make it fixed value so it should not get updated even I make any field selections in the application.

Thanks in advance

[Anonymous]

I would suggest a otherway , create a straigt table with the same expression and dummy dminesion(like =1 and in the presentation tab of  properties check hide column radio button) .

then ditach the object.

it will not reflct for any selections.

I do not see detach option for text object.

BR,

Chinna

[#3]

there are no way to solve this in the text object ??

[its_anandrjs]

Hi,

You can try SET expression in the expression like

=NUM(((sum({1} T_NST_CD_OUTQTY1_DAY_RW)/T_NST_ELAPSED_DAYS)/AVG(AGGR(SUM

(T_MERRTE_STEP_COUNT),T_NST_DEVICE)))*T_NST_MAXMONTHDAYS,'###,##0')

Or

You can create any variable and then try to use it here

vExprVar =

=NUM(((sum({1} T_NST_CD_OUTQTY1_DAY_RW)/T_NST_ELAPSED_DAYS)/AVG(AGGR(SUM

   (T_MERRTE_STEP_COUNT),T_NST_DEVICE)))*T_NST_MAXMONTHDAYS,'###,##0')

and use it in text object like

=$(vExprVar)

Hope this helps

Regards

Anand

[#5]

it doesn't work.. anyway. thanks Chouhan.

[Anonymous]

Hi,

Try to use set analysis with 1 so that it can use all the values . No matter what selection you have made.

[jagan]

Hi,

Try like this, you need to give {1} in all aggregation functions

=NUM(((sum({1 }T_NST_CD_OUTQTY1_DAY_RW)/T_NST_ELAPSED_DAYS)/AVG({1}AGGR(SUM

({1}T_MERRTE_STEP_COUNT),T_NST_DEVICE)))*T_NST_MAXMONTHDAYS,'###,##0')

Regards,

Jagan.

[its_anandrjs · Accepted solution]

Try once this one with {1}  as i post earlier also with both numerator and denominator values.

=NUM( ( ( Sum( {1} T_NST_CD_OUTQTY1_DAY_RW ) / T_NST_ELAPSED_DAYS )

   /

  AVG( {1}  AGGR(SUM( {1} T_MERRTE_STEP_COUNT ), T_NST_DEVICE ) ) )

*  T_NST_MAXMONTHDAYS,'###,##0' )

Regards

Anand

[#9]

Hi hyunseok ,

the values are getting diffrent because in your formula

(sum({1 }T_NST_CD_OUTQTY1_DAY_RW)/T_NST_ELAPSED_DAYS)

for T_NST_ElapsedDays you didn't use any aggregation function , while your sum(T_NST_OUT_QTY1_DAY_RW) doesn't affect with filter.

if your formula is getting you the correct value, then you can apply sum or avg in front of this and write

(sum({1 }T_NST_CD_OUTQTY1_DAY_RW)/sum({1}T_NST_ELAPSED_DAYS))

/

AVG({1}AGGR(SUM

({1}T_MERRTE_STEP_COUNT),T_NST_DEVICE)))*sum({1}T_NST_MAXMONTHDAYS),'###,##0')

With Regards

Harshita Gaur