Variance of values in same column

Question

HI All, I have a column I created with this formula "Sepsis HAI or Non = if([SEPSIS]="Y","HAI Sepsis",if([HAI or Non]="Non","No Sepsis",""))" it returns only values of:&nbsp;HAI Sepsis or No Sepsis or a blank. I can not figure out how to create variance between the columns items of HAI Sepsis and No Sepsis, then place it in a matrix to create the&nbsp;BOLDED line below in my matrix.&nbsp;EX:&nbsp;Month&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2018-1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2018-2Financials&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cases&nbsp;&nbsp;&nbsp;&nbsp; ALOS&nbsp;&nbsp;&nbsp;&nbsp; Tot Cost&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cases&nbsp;&nbsp;&nbsp;&nbsp; ALOS&nbsp;&nbsp;&nbsp;&nbsp; Tot Cost&nbsp;Hospital&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4.3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;76&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4.2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3,500&nbsp; HAI Sepsis&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6.2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6.2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,250&nbsp; No Sepsis&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 70&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 68&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,250&nbsp;&nbsp;&nbsp; Variance Sepsis&nbsp;-60&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-60&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,000&nbsp;Thanks for any help you can offer.&nbsp;Terry

v-yuta-msft · Answer

Hi&nbsp;tbobolz,
&nbsp;
"I can not figure out how to create variance between the columns items of HAI Sepsis and No Sepsis"
&nbsp;
&lt;--- Could you share your original table with column [HAI Sepsis] and [No Sepsis] and clarify the logic of how to achieve the variance?
&nbsp;
Regards,
Jimmy Tao

tbobolz · Answer

Hi,&nbsp;Thanks for the review.&nbsp;My table does not have a column for HAI&nbsp;Sepsis and No Sepsis, rather these two&nbsp;values are the result of a&nbsp;measure in one column. This is why I am struggling. &nbsp;I would like to create a row that calculates the variance between these two rows so that it displays the difference in the two rows, but the difference for the number of cases, ALOS (Average length of stay, and Tot Dir Cost.&nbsp;Here's a link to my file with mock data.&nbsp;Thanks in advance for any help you can offer.Terry&nbsp;&nbsp;https://1drv.ms/u/s!AjtlvXqTqtRPvWbQdblrjecBcVa3

Forum Discussion

Variance of values in same column

2 Replies

Related content

Variance column for Dynamically selected columns

Variance Column

Variance Column

Splitting Column values

Matching Column Values