Calculation with missing fields

[sbjkiss]

I am testing Alteryx for applicability of various use cases.  We use Essbase a lot so I am trying to manipulate the cube data to generate calcs and subsequent reports.

My current issue is that I need to generate a calculation off a field that may or may not exist based on the filters used to retrieve the data.  Different months, different lines of business, etc.  I know there could be ways to set up a static list of necessary fields and populate missing ones with a zero.  

However, since the Essbase hierarchies may change I need something a bit more flexible.

I am pivoting the data to do calcs on the rows. 

I was hoping to find something like an IF Exists function to use against the fields before processing the calc.

[Amarendra]

Are you able to wrap your columns in an IsEmpty() ?

You can use the dynamic replace and IsEmpty() to handle all the fields that you expect to be nulls. I would give that a shot

[sbjkiss]

Thank you!  I'll look it over and let you know.

[sbjkiss · Accepted solution]

I ended up just extracting the full hierarchy with each run.  The time it takes to do this is inconsequential.  This way I will always have the fresh tree.