Have you ever wondered how the Calculate if No Data setting works? (I
did, and Keith Berry helped me out)“Calculate if No Data = False”
prevents the execution of rules on “OK,NA” (no data) entity. However,
the Calc Status gets changed from “OK,NA” to...
I was asked today, 'Am I correct to think that Databuffers do not return
Null/Blank cells and therefore you don't need to check whether the
cellstatus is Not NoData?' The full data unit is in memory and Time is
part of that. The system needs it in me...
General FormattingOne of the most important things you can do to make
you rules readable and helpful is to make sure they are properly
formatted. There are some simple rules you should always, without
exception follow. The rules of good formatting ar...
Equity Accounting And Methods A consolidation method is just a way to
treat an entity during consolidation based on how much of it you own or
control. It makes sense, if you only own 10% of an entity, and another
entity has an asset recorded for the ...
Equity pickup (EPU) is a method of reevaluating the investments owned by
a holding company allowing the parent to realize changes in equity. This
results in the holding company’s balance sheet showing the current value
of the corresponding share in t...
One option people do when creating a people planning application is to
not put names/titles and salary data all together. Meaning they might
just use employee id, or some other information. When that isn't an
option, you can create an application tha...
My first thought is if you used the member filter in the formula you
could call all base accounts under IncomeStatement. As an example
-api.Data.Calculate(formula, accountFilter, flowFilter, originFilter,
icFilter, ud1Filter, ud2Filter, ud3Filter, ud...
You can add Force Translations in the workflow, as part of the Run
Calculate step. And I like this option much better than having the
system try and guess based on where data is. The reason is that there
are times when no one will enter data and you ...
The short answer is YES. You can do this with rules, pretty easily. In
fact, you don't need to do the whole elimination calculation, you just
need to tell the rules where to you want to see the elimination in the
hierarchy. Then add this line in your...