This content has been marked as final. Show 7 replies
I would suggest to use Column Properties->Data format in Criteria tab instead of handling in case statement.
If helps pls mark
the Column Properties->Data format seems to apply the rule to all data in the column , whereas need to apply formatting depending on which Currency...
I dont think you can do that, in the rpd if the column is set decimal you have to use column properties to show exact decimals.
if the value is 5.00 or 5.05 in the report with out settings its 5.
if not you need to convert to char and use string functions
In the column Expression formula in the Report you can use Case when Statement
Case when Currency =Dollar then Round(Value) else Value
you can also use Truncate Fuction based on your Requirement
At RPD make the column Decimal
Edited by: forankit21 on Nov 19, 2012 11:22 PM
It can be done as given below:
CASE WHEN Currency = 'USD' THEN round(dollar_column, 0) ELSE round(dollar_column, 2) END
Column Properties --> Data Format
1. check "Override Default Data Format"
2. Treat Numbers As "Number"
3. Decimal Places select "upto 2" in the drop down.
This should do the trick.
Let me know if this helped.
Edited by: SQhell on Nov 20, 2012 8:42 AM