Forum Discussion

jeffvdt's avatar
jeffvdt
New Contributor II
6 months ago

CVR on two row members

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...
  • Henning's avatar
    6 months ago

    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's avatar
    6 months ago

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

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