Print Page | Close Window

Converting values to percentage

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22637
Printed Date: 25 Apr 2024 at 2:42pm


Topic: Converting values to percentage
Posted By: shabbaranks
Subject: Converting values to percentage
Date Posted: 05 Jul 2018 at 4:24am
Hi,
I've managed to get a value of a margin as a cost into ColumnC

so "ColumnA SalesVal" - "ColumnB Cost" = "ColumnC Profit"

But when I try and convert the Profit to a percentage

ColumnC Profit \ ColumnB Costs * 100

I get 0.

Any ideas? Thanks



Replies:
Posted By: kevlray
Date Posted: 05 Jul 2018 at 9:14am
Wrong slash, that slash (\) gives the modulo.


Print Page | Close Window