Performance Tuning

[jessechan]

The following is my expression:

1. [Paper -ve Yield1]/[ProductSales] = running time 1 min

2. average(total([Paper -ve Yield1]/[ProductSales]for[StoreNo],[YearMonth]) for [YearMonth],[MainStorePriceTier],[IsMcCafe],[Sales Range]) = running time 9 min


So, I dont know why it takes long time to run if I added "for" expression.
Is there any way the minimize the running time for expression 2?

[manjunathgowda]

Hi,

why cant you create same logic in FM!!!
try it once, use it in report later