IF statement based on variance data
IF statement based on variance data.
I am not sure if Xero HQ is where it needs to be requested, but the FORMULAS in REPORT EDITING are too strict. Please allow FORMULAS to include VARIANCE data/coloumn. I want to create a report that allows FORMULA to be driven from the variance data only - and not include other bulky data not required. For example, in the attached screenshot - I only want to show the GREEN data. TRADING INCOME = a group of accounts, summarised. Variance coloumns are XERO coloumns. BONUS = is to equal 30% of the increase IF the increase was greater than 1.5%.
1
vote
![](https://secure.gravatar.com/avatar/5cf30663d7fcecf1baf88d43087f232e?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)