CVR on two row members

[jeffvdt]

Hi All,

Can somebody maybe help me on this one? I want to add some subtotals in my report but  the problem is that i need to add two members to the CVR formula. So as shown in the formula below not only deferred taxation (account) but also the UD3 (<1 Year) to get the complete data field to sum. How can this be achieved?

[Henning · Accepted solution]

Hi, I am not sure whether I understand the request correctly. I assume you wish to get the sum of all three rows under Deferred taxation, correct? In your description it sounds as if you only want to get the first row.

You should be able to do it e.g. like this:

GetDataCell(S#Actual:A#40000 + S#Actual:A#40010):Name(MyCVRResult)

[Henning · Accepted solution]

Hi, I am not sure whether I understand the request correctly. I assume you wish to get the sum of all three rows under Deferred taxation, correct? In your description it sounds as if you only want to get the first row.

You should be able to do it e.g. like this:

GetDataCell(S#Actual:A#40000 + S#Actual:A#40010):Name(MyCVRResult)

[pranav46 · Accepted solution]

here the function you can try or create a member with formula and pull in cb.

GetDataCell(UD7#membername+UD7#membername):Name(Total)