Calculations Looking at Profitability in Lumira
I am still using a sample dataset of sales, profit by category, region and order date.
First I create a calculation that looks at each record to determine profitability:
If the profit ratio is greater than zero, then it is profitable; otherwise it is not.
Next I can visualize how this looks:
I can create another calculation showing the percentage of total:
This is how the table looks:
Next I can send the table by e-mail:
I select Keep table totals:
Then I can send by email:
I can open in Excel:
I notice some rounding differences between Excel and Lumira. It looks like Excel rounds up, but Lumira does not.
Also, the grand total is lost in Excel.
Be the first to leave a comment
You must be Logged on to comment or reply to a post.