开发者

Group footer subtraction

I am a newbie i want to know how you can subtract GF2 values one after the other .I have 4 new sub heading i need to create,for example GF2.A-GF2.B = Gross profit GF2.B-GF2.C = Operating profit GF2.C-GF2.D = Profit before t开发者_如何学Goax GF2.D-GF2.E = Net profit and how do you alternate the contents of label in GF1 like Gross profit ,Operating profit,Profit before tax and Net profit to show when needed.Dynamically


In formulas in the group footer of your balance sheets, you can refer to the summary values like this: sum({table.ThingToSum},{table.ThingYouGroupOn}. So that would be like your "Field A". So, to get Gross Profit for example, you could you could create a group footer formula like this: sum({table.colA},{table.balanceSheet}) - sum({table.colB},{table.balanceSheet}) where colA and colB are the two fields you were summarizing before.

To get your Net Profit, you could refer back to the result of the formula you made above with something like this {@Gross Profit} - sum({table.colC},{table.balanceSheet}). If {table.colC} holds, say, taxes or other deductions.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜