Attribute decimal display

[Rambo2292468]

Hi,

I have an attribute named Quantity. I use the formatting below (backend data is teradata) to display the data with decimal:
ApplySimple(" cast(cast (#0 as decimal(12,3)) as char(12))", [item_required_amount])



From this formatting, it displays the data as follow: 1.000, .000, 1.123. However, my customer is very picky about this. In the case 1.000, she only want to see 1, in the case 0.000, she wants to see 0 only, not decimal. However, in the case backend data has 1.123, she wants to see 1.123.

 

[FLB]

You can try to use a case statement like (syntax NOT checked):

case when (cast(cast (#0 as decimal(12,3)) as char(12)) <> (cast(cast (#0 as decimal(12,3)) as char(12)) then (cast(cast (#0 as decimal(12,3)) as char(12)) else case when (cast(cast (#0 as decimal(12,2)) as char(12)) <> (cast(cast (#0 as decimal(12,1)) as char(12)) then (cast(cast (#0 as decimal(12,2)) as char(12)) else case when (cast(cast (#0 as decimal(12,1)) as char(12)) <> (cast(cast (#0 as decimal(12,0)) as char(12)) then (cast(cast (#0 as decimal(12,1)) as char(12)) else (cast(cast (#0 as decimal(12,0)) as char(12)) end case end case end case end case