Forum Discussion

PFugereCSO's avatar
PFugereCSO
Icon for OneStream Employee rankOneStream Employee
3 years ago

Calculate if No Data

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...
Consolidation
Cubes
Jasper's avatar
Jasper
New Contributor II
2 years ago

From the "Designing an Application" course:

This seems to say that running a regular Calculate on a OK,NA Data Unit, with Calculate if no data = True (i.e. top left square in the table above), will execute the rules for the data unit.
The top left square above says it will not execute the rules in this case, and you have to Force Calculate (top right square) for the rules to run.

Which one is true, or what am I missing?

  • KarlT's avatar
    KarlT
    Icon for OneStream Employee rankOneStream Employee
    2 years ago

    I think they are both true but the Designing an application is not talking about the difference between a force calculate and regular. As Peter shows in his table, the "regular" calculate simply never executes on an "OK,NA" status. Whereas the force will check this setting and either run the rules or not, but regardless will change the status to "OK".