EPMCellRanges

[sreeraj_sukumaran]

How EPMCellRanges works?

[Former Member · Accepted solution]

Hi Sreeraj

You can use the EPMCellRange with other EPM formula where we can select range of cells dynamically as shown in below example..

example :

JAck

[Former Member · Accepted solution]

Thanks Jack! 

So, we can use this EPMCellRange formula in any EPM function having 'SourceRange' field.

Is it? Can you tell me if there are more uses of this function in EPM.

Thanks

Venkat

[Former Member · Accepted solution]

Hi Cvraman

Different EPM function have different field name , not always SourceRange.

EPMCellRange is similar to what you do in excel ie select range.

It is not mandatory to use EPMCellRange , you can use normal excel range selection also.

another example :

JAck

[Former Member · Accepted solution]

Ok. got it!

Thank you Jack!

Venkat

[sreeraj_sukumaran · Accepted solution]

but it can be done without EPMcellRange( using the address itself)