Forum Discussion
Divide a column value by another column in Matrix or table layout
You can include a column(%Overdue) and use the formula that you had used earlier but ensure to set the format for
%Overdue as Percentage and set the Default Summarization to Don't Summarize
Thanks for your help Banurekham. It works, but it stems out another issue. My data is filtered by organization and location, as soon as I apply divide function to %Overdue column the rows from single organization and location split into two. Something like this
Before:
Org Loc Case counts Overdue cases
WA ABC 18 9
After:
Org Loc Case counts Overdue cases %Overdue
WA ABC 9 0 0.0%
WA ABC 9 9 100.0%
Please advise.
Could you share the snapshot of the model or your sample data
The data is sourced from a table in a spreadsheet. I figured out the error, I didn't pull the data from another related spreadsheet.
Thanks