2 Replies Latest reply on Apr 20, 2019 1:05 PM by Dan Gomes

# Calculate Percent based on Row

Hi Guys,

In simple words, I have a report that has two rows with date in colums. The first row are Offers made to customers in that period, the second row is the number of customers that purchased the offer.

I want to include a third row to show ratio of Purchase/Offer in percent. Show all three rows.

See matrix and sample twbx attached. Thanks in advance.

 Type Jan-19 Feb-19 Mar-19 Apr-19 Offer 9,166 10,693 19,978 4,384 Purchase 3,894 4,297 6,323 1,369 % Purchased 42.5% 40.2% 31.6% 31.2%
• ###### 1. Re: Calculate Percent based on Row

Dan,

Make a calculated field: Percent:

{FIXED [zCF_Period]:(SUM(IF [Type]='Purchase' THEN ([Counts]) END)/SUM(IF [Type]='Offer' THEN ([Counts]) END))}

and move it to "dimension" , then drag it to columns, set number format to percent.

Hope it helps.

Michael Ye

7 of 7 people found this helpful
• ###### 2. Re: Calculate Percent based on Row

Mike,

Thanks. I had tried the FIXED formula but I had the syntax wrong.