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?
Hi,
why cant you create same logic in FM!!!
try it once, use it in report later