Skip to main content
M
Manjunathak
June 14, 2024
Solved

Workflow profile - Calculation Defination

  • June 14, 2024
  • 2 replies
  • 2 views

Workflow form has different scenarios Actual, forecast.

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


Manjunathak_0-1718372880653.png

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.

Best answer by Henning

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.

2 replies

A
aformenti
June 14, 2024

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.

 

M
ManjunathakAuthor
June 14, 2024

Hi aformenti 

i tried changing both it didn't work

H
Henning
June 14, 2024

What is the scenario in your workflow POV?


Henning_0-1718374496292.png

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.

M
ManjunathakAuthor
June 14, 2024

workflow scenario is Actual 


Manjunathak_0-1718375751413.png

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


Manjunathak_1-1718376055979.png

 

 

 

H
HenningAnswer
June 14, 2024

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.

Terms & ConditionsAccessibility statement