OneStream Community

WillVitale

Hello, I was wondering if it's possible to have a check figure if the amount equals 0 that it displays "OK" and if it doesn't it says "Check Details". I've tried conditional formatting when the cell amount = 0 then "OK", but I figured I'm missing som...

WillVitale

Hello, I'm trying to sum up a calculated amount using Row Column Intersection and I cannot get it to work properly. I'm using Rows Override in order to sum up these calculated amounts (also using row override). So the Input Inventory Amount, I put so...

WillVitale

Hello, I created a new Scenario and assigned it as ScenarioType 3. I went into Application Properties and made sure ScenarioType2 general and dimensions were set up for it. I then went into the Workflow Profile and created a new Form under one of the...

WillVitale · 03-19-2024

Hello, I was wondering if we can have forms only populate for certain months. I tried using the Form Frequency filter as Member Filter and tried a few different things to no prevail. I only need the form to show up in the WF for months 1-10 and I tri...

WillVitale · 03-13-2024

Hello, I was wondering if there's a time expansion that would only pull a previous year based off the workflow? I tried WFPrior2, but that pulls both prior 2 years. If I want to just pull the time form 2 years ago (i.e. 2022) how could I do that base...

WillVitale

Hi Jack, I understand what you're saying, but the formula I have is a GetDataCell calc subtracting from a some accounts. Does that still work? Will

WillVitale

Hello, No, annotation is not what I want. I have my column currently doing a calculation to determine if the cell is 0 or not. I was just wondering like in excel if you do like If(cell x=0,"OK","Check Details"). Something like that.

WillVitale

Thanks Jack for all the information. I really appreciate it! Will

WillVitale

Hi Jack, So I was able to get it to work after some tinkering, but now I cannot figure out how to roll up those amounts into the parent I created. I made it set to Is Consolidated and ran a force consolidate but that didn't end up working. I compared...

WillVitale

Hi Jack, So I followed that link and I tried creating a UD8 calc based off of something we already had but I'm not sure if this works or not. I'm guessing it's a lot easier than I make it out to be, but any direction would be great. Thanks, Will

OneStream Community

User Statistics

User Activity

Cell Value Showing "OK"

Row Column Intersection in a Cubeview

Scenario Type 3 Not Showing Up in Workflow Profile

Forms Only Available in Certain Time Periods

How to pull a past year only that's not the past year

Re: Cell Value Showing "OK"

Re: Cell Value Showing "OK"

Re: Row Column Intersection in a Cubeview

Re: Row Column Intersection in a Cubeview

Re: Row Column Intersection in a Cubeview