If Challenge

[pnn44794]

Hello:

I'm having a challenge where I've built a user customizable table (credits to Richard Pearce) and some of the fields that can be included are dollar amounts.  The problem is that these dollar amounts are not formatted as such.  I can't format them in the load script as the fieldname is a literal, so if I try to use Num for example, Num becomes part of the fieldname.  So, I'm thinking that I need some type of If statement wrapped around the following calculated dimension, but I don't know how to do so:

=$(=FirstSortedValue(DI_Dim_FieldName,DI_DIM_SortOrder,1))

I have 10 of these calculated dimensions where each one would need to account for, minimally, two different dollar amount fields (Estimated Save and FB_MYP_Annualized_Benefit) or leave the field as is.  Does that make sense?  The reason I have to account for them in all 10 calculated dimensions is because the end user can choose the sort order of the columns.

As always, thanks in advance fro any and all help.

[Anonymous]

can you post your app?

[pnn44794]

Hello Wallo:

Give me a few and I'll post something that you can work with.  Please note that I need to remove some data, but not anything that would prevent a solution.  When I post it, I'll provide more info to hopefully help.  Thank you in advance.

[pnn44794]

Sorry for the delay.  I've attached the qvw file and sample data.

Again, I'm interested in formatting dimensions Estimated Save and MYP Annualized Benefit (and FB_Annualized Benefit) if they are one of the chosen fields.

[sunny_talwar · Accepted solution]

May be try to change the format settings for the specific field from Document properties tab

[pnn44794]

Hello Sunny:

As always, thanks for the reply.  That worked.  I didn't know you could do that, so I've learned something new and thanks for that.  Also, again as always, thank you for your help!!!  It's very much appreciated.