Workflow profile - Calculation Defination

[Manjunathak]

Workflow form has different scenarios Actual, forecast.

I have created the step for Force Consolidate and Scenario Type filter is set to (ALL).

when i complete the form only Actual Scenario will consolidate but not forecast scenario.  i tried to add another step to consolidate forecast scenario but it didn't work. 

May i know how to set up for all scenarios to be consolidate at once.

[aformenti]

HI @Manjunathak ,

Looks like you have the Entity filter wrongly set up. You can't select assigned entities if what you want to do is to Consolidate. You need to point the entity to the Level you want to consolidate and select Cons Local.

[Manjunathak]

Hi @aformenti 

i tried changing both it didn't work

[Henning]

What is the scenario in your workflow POV?

When you say "when i complete the form only Actual Scenario will consolidate but not forecast scenario", what do you mean exactly? Do you have an input form that you use to enter Actual and Forecast data to in the same form?

To add to the comment of @aformenti, what he means is you need to select a parent entity to consolidate.

[Manjunathak]

workflow scenario is Actual 

the form is available only in Actual scenario but i have the entity assigned to forecast scenario also.

First column in form has Actual data  and other columns has forecast scenario data, want to compare the Actual numbers with forecast. i need to consolidate each column separately to have numbers that's reason i'm looking for calculation definition step to consolidate for both actual and forecast scenarios

[Henning · Accepted solution]

I may be the exhausting week talking and I hope I am not missing anything here, but I am fairly certain that the Process definition calculates your WF POV scenario. Which in your case is Actual, which is why Forecast (LY) does not get calculated as it is not in the WF POV.

There are other ways to trigger the LY calculation such as dashboard buttons, data management jobs, or NoCalculate steps with a workflow event handler. Or you change the scenario in your WF POV to LY and Process it there.