Forum Discussion
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...
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
Community Champion
Community Champion
The inclusion of all the other values is generated by the +0 at the end of your formula.
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...