Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
I'm trying to add a calculation to an equity account in Row Definitions. Do I select 'Format Code' as 'CAL'? I would like to just do Account = [xxxx] * tax rate
What's the simplest way to do this? Thanks so much.
Yes for 'complex' calculation you must select CAL.
Does it work?
Do you need to show just this % on that row or you need to show your full equity on one row and tax calculation on a different row?
Thanks for your fast reply. I just want the row to show an equity component * tax rate in one cell. If I use ‘CAL’, it won’t let me enter anything else on that row. Is it possible to have a calculation within one cell or to “hide” the tax rate somewhere?
So this is how i would do it.
Thanks! I'm almost there. My problem now is that the equity line items are correct, but 'Total Stockholders' Equity' doesn't foot correctly. I multiplied an equity account by 80%, and now the total equity is off by 20%. Should the 'NP' take care of that?
The equity total is factoring in the 20% when I don't think it should, so my balance is too high by this 20%.
This is just like Excel. You sum rows and eliminate some. TOT is for easy calculations + or -. CAL is for more complex ones with divisions and multiplications..and you must put @ sign before the row number when you use CAL. Otherwise, it will consider your row number as a regular number and use it in the formula as an amount. :)
But here is what is missing
Please note this as correct answer.
Thanks! So helpful!
How did you get Financial Dimensions to say "MAINACCOUNTCATEGORY = [OTHERINC]" etc....? Is this through the Dimension Value Set?
Don't be scared of clicking in the cells and exploring. :)
Setting a column name to be "December 31, 2017", which option would one choose? @EndDate is close, but I'd like the month name. Also, is there a print preview capability so I don't have to wait 20-30 seconds each time to see a change I just made?
Any idea for this above question from 6/14 10:35am?
To my knowledge, I believe it is not possible to have the date written this way December 31, 2017.
And no there is no way to preview, you need to generate each time. I know it is a long process. But it is a normal process. Once you know the tool, you will set your reports once and for all. And you wont need search anymore. But you must go through the process.
Business Applications communities