Skip to main content
Amelia Kohm 님이 #Tableau Desktop & Web Authoring에 질문했습니다

I'm getting the wrong result from a simple subtraction calculation. Thinking that I might need to aggregate the calculated fields, I wrapped each field in a sum, but the result is still wrong. 3,808-3,426 should be 382 (rather than 377).

 

Here's the calc:

 

Difference in Number of Gifts YTD, Current to Prior Year

 

SUM([Number of Gifts YTD Current Year])-SUM([Number of Gifts YTD Prior Year])

 

Here's the result:

Getting wrong result from subtraction calcuationI would greatly appreciate any suggestions! Workbook attached.

답변 3개
  1. 2021년 2월 19일 오후 10:09

    No worries! We've all been there and done that at some point!! Best, D

0/9000