When do a formula on a number and another formula 1 on that formula 2 in the same table then rollup the formula 2 into another table when I try to sum it in the new table it gives me a number that is different from the first number. I did some trouble shooting and rolled up formula 1 and the number was persevered I could then go on to carry out formula 2 in the new table. Is there another way of getting around this as I would like to do both formulas in the first table.
Any help will be appreciated. Thanks in advance