Hi,
I have tried and tried again but keep getting errors. This is the formula I am trying to use this formula is looking at our qty which is a formula field and dividing the last 7 days sales.
min({custitem14})/ nullif(((Case when {transaction.account} = '1100 Sales' and ({today} - {transaction.trandate}) BETWEEN 0 AND 7 then decode({transaction.type}, 'Sales Order' , nvl({transaction.quantity},'0'),0) + decode({transaction.type}, 'Currency Revaluation', nvl({transaction.quantity},'0'),0) else 0 end) / 7),0)
If I split the formula - then both work but not when I join them. I have tried putting nullif in front of min, but still throw invalid expression. im sure i'm missing one small thing but right now :h_a_w:min({custitem14})
nullif(((Case when {transaction.account} = '1100 Sales' and ({today} - {transaction.trandate}) BETWEEN 0 AND 7 then decode({transaction.type}, 'Sales Order' , nvl({transaction.quantity},'0'),0) + decode({transaction.type}, 'Currency Revaluation', nvl({transaction.quantity},'0'),0) else 0 end) / 7),0)
If this formula works, I want to expand it to look at 14 days too. please could someone help methanks