Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Multiple formats for the same cell? Expand / Collapse
Author
Message
Posted Thursday, February 7, 2013 1:59 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 7:05 AM
Points: 17, Visits: 19
I am wondering if this is even possible....

I have a parameter that lets the user select various options, all starting with either 'Count' or 'Amount'

This then feeds into a matrix with Program as the row and Date as the column with the paramter metric they selected in the table.

I want to format the cell to either currency if they select an 'amount' parameter or numerical if they select 'Count'

Is this possible and if so, how would I go about doing it?
Post #1417346
Posted Thursday, February 7, 2013 3:23 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 7:05 AM
Points: 17, Visits: 19
I figured it out, and it was much easier than I thought :)

=iif(left(Parameters!Search.Value,6) = "Amount","'$'#,0","#,0")

Post #1417373
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse