Discussions
Financial Report Builder
Hi - I have an infuriating issue and maybe I am missing the obvious. In a P&L statement I have a variance formula column 'Actual - budget' i.e. using 'Difference x - y' : so for sales actual less than budget gives an unfavourable negative variance which is fine. The same formula however for costs when actual cost is less than budget needs to be a favourable, positive variance. A colleague mentioned the 'reverse sign' option but that appears to work across all columns in the layout. Can anyone help please ?
Thank you, Steve Barrett