Forum Discussion

williamdasilva's avatar
williamdasilva
Regular Visitor
9 years ago
Solved

Calculated Column breaks Relationships

When adding a calculated column to the output values on a visual (grid), the relationship seems to be broken and a "full outer join" is applied between the two implicated tables.   Basic tables inv...
Need Help
  • williamdasilva's avatar
    williamdasilva
    9 years ago

    Obviously something wrong with that Calculated column.

     

    I've opted instead for doing a query method. Duplicated the actions table, filtered on the ones I want to count, did a group by, then a merge back into Records table.

     

    Not so elagant, but returns the correct results and does not drive me insane!

     

    Would love to get that Calculated column working properly though.

     

    Thanks,

    William

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

williamdasilva

 

The inclusion of all the other values is generated by the +0 at the end of your formula.

williamdasilva's avatar
williamdasilva
Regular Visitor
9 years ago

Vvelarde The +0 was there to avoid NULLS (or Blanks).

 

When I remove the +0, records that return NULL from the calculated field are excluded from the output!

 

Results without calcuated field

 

results with calculated field (simply added the field)

 

No filters...

  • williamdasilva's avatar
    williamdasilva
    Regular Visitor
    9 years ago

    Obviously something wrong with that Calculated column.

     

    I've opted instead for doing a query method. Duplicated the actions table, filtered on the ones I want to count, did a group by, then a merge back into Records table.

     

    Not so elagant, but returns the correct results and does not drive me insane!

     

    Would love to get that Calculated column working properly though.

     

    Thanks,

    William

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi williamdasilva,

      I am very gald to hear that your issue got solved. Please mark your solution as answer, others will find workaround easily.

      Thanks,

      Angelia