| Author |
Topic |
|
v_kash
Starting Member
45 Posts |
 Posted - 2009-01-08 : 11:55:45
|
| if anyone can help me with this, it would be greatly appreciated. in a report i have, i have built a 'summary table'. anyways there are two columns in this table. 1 column is metric, and the other column is total_active_commercial_accounts. i have two values in the metric column (active accounts, and sales). However, i want to update the total_active_commercial_accounts, where the metric is total sales to a currency format (meaning i want to show the dollar sign). when i do this, it updates everything in the column to show the $ sign. I ONLY want to update the intersect value where the metric is total sales. any suggestions? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-08 : 11:58:06
|
| I ONLY want to update the intersect value where the metric is total salescan you explain what you mean by intersect? |
 |
|
|
v_kash
Starting Member
45 Posts |
Posted - 2009-01-08 : 12:02:52
|
| yes, for example -Metric Total Active Commercial AccountsActive Accounts 318Sales 114569.2so lets say that is my table. I want to display a currency symbolfor the total active commercial accounts value, where the metric = sales. i dont want the dollar sign to show up for the 318, but only for the 114569.2. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-08 : 12:10:32
|
| =IIF(Fields!Mtetric.value="Sales","$" & Cstr(Fields!TotalActiveCommercialAccounts.value),Fields!TotalActiveCommercialAccounts.value) |
|
|
|
v_kash
Starting Member
45 Posts |
Posted - 2009-01-08 : 12:16:38
|
| will try it! thanks for the quick response! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-08 : 12:20:29
|
| welcomelet us know how u got on! |
|
|
|
v_kash
Starting Member
45 Posts |
Posted - 2009-01-08 : 12:52:50
|
| hey it works somewhat - when i put the code in, it does put the dollar sign for that value, but its not workign 100%. for example, when i run it, i am expecting to get back a value of 1214.22. the value it brings back in the report is 12141214 (so it is appending the value) |
|
|
|
v_kash
Starting Member
45 Posts |
Posted - 2009-01-08 : 14:39:27
|
| hey visakh, i figured it out,,i was putting the code in the 'format' option of the expression, thus it was appending the values..i had to put it in the expression itself..it works,,thanks! |
|
|
|
v_kash
Starting Member
45 Posts |
Posted - 2009-01-08 : 14:42:21
|
| if i wanted to add a comma to to the result set (thousands separator),,how would i do that?right now i am doing this - =IIF(Fields!metric.value="Sales","$" & Cstr(Fields!Total_Active_Commercial_Accounts.Value),Fields!Total_Active_Commercial_Accounts.Value). so a result might yield me $13585.51. I want it to show up as $13,585.51. thanks once again!! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-09 : 11:51:07
|
quote:
Originally posted by v_kash
if i wanted to add a comma to to the result set (thousands separator),,how would i do that?right now i am doing this - =IIF(Fields!metric.value="Sales","$" & Cstr(Fields!Total_Active_Commercial_Accounts.Value),Fields!Total_Active_Commercial_Accounts.Value). so a result might yield me $13585.51. I want it to show up as $13,585.51. thanks once again!!
go to format window and you've some standard formats available for currency one of which contain , seperation |
|
|
|
v_kash
Starting Member
45 Posts |
Posted - 2009-01-09 : 15:05:58
|
| yep was gonna post earlier,,this is what i did,,n it works,,thanks -=IIF(Fields!metric.value="Sales" or Fields!metric.value="GP",formatcurrency(Fields!Total_Active_Commercial_Accounts.Value),Fields!Total_Active_Commercial_Accounts.Value) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-10 : 02:36:02
|
| welcome |
|
|
|
|
formatting problem