Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
there are no way to solve this in the text object ??
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
it doesn't work.. anyway. thanks Chouhan.
Hi,
Try to use set analysis with 1 so that it can use all the values . No matter what selection you have made.
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.
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
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