2 Replies Latest reply on Aug 23, 2016 7:44 AM by Akhilesh Singh

% Calculating Wrong

Akhilesh Singh Aug 24, 2016 9:07 AM

Hi All,

I have Three measures. First () sum is 1,442,640, Second Sum is 117,044,001 last one is for Percentage calculation First/Second. It should be 81.87%. But it is giving me 76%.

Below are the calculation for Percentage

IIF([Second]=100,0,

(ZN([Second]*[First],0))/[First])

Please help me. How can i solve these type of issues.

1. Re: % Calculatting Wrong

Tom W Aug 22, 2016 3:15 PM (in response to Akhilesh Singh)

It's pretty much impossible to help you with this without you providing sample data in a Tableau Packaged Workbook.
Like Show 0 Likes(0)

Actions
2. Re: % Calculatting Wrong

Akhilesh Singh Aug 23, 2016 7:44 AM (in response to Tom W)
Hello Tom,

Required files are attached for your reference. Highlighted number should be 119849/1464 = 81.86.

Book1.twbx 35.0 KB

Sample Data.xls 102.5 KB
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

% Calculating Wrong

1. Re: % Calculatting Wrong

2. Re: % Calculatting Wrong

Actions

More Like This