I have a saved search which uses a formula to derive YTD sales. I want to divide this result by the value of another field. How do I do this?
Here is the formula to get YTD sales;
Case WHEN {transaction.account} like '%6000%' and TO_CHAR({today}, 'YYYY') = TO_CHAR({transaction.trandate}, 'YYYY') then (Case when {transaction.type} in ('Invoice', 'Cash Sale') then {transaction.amount} else 0 end ) else 0 end
Any help is appreciated.