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%.
Nicholas Cole
supported this idea
·
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%.