Filter on Calculation Field

Follow

Jeff Dougherty

• February 09, 2016 16:51

I have a calculation field that draws the "Cost Center" from another related app. I would like to filter by cost center, so I've done the following:

var a = parseInt(@All of Cost Center, 10) || 0;
a

That works, gives me a #, and can filter, but I'm getting the #  :  2,3813.00

I would like to only have :  23813

I've searched the net and found many solutions (.replace, etc), but none have worked?

Any suggestions?

0

• 

  Hamid

  • February 09, 2016 22:29

  Go to  your calculation field in the template  editor and change the number of digits after comma to none in the 

  drop down menu

  0

  Comment actions Permalink
• 

  Jeff Dougherty

  • February 10, 2016 14:57

  Thanks totally missed that one. I'm still unable to get rid of the commas though?

  Tried to insert  :  .replaceall(/,/, "") but that didn't work.  (undefined is not a function)

  Any thoughts on that one?

  0

  Comment actions Permalink
• 

  Hamid

  • February 11, 2016 13:45

  Have you tried with parseFloat()  instead of parseInt()

  create a new calc field to do this

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • February 11, 2016 15:03

  Hi Jeff,

  you can't .replace() on numbers, only on strings. (btw: for replacing all you must use the flag "g": string.replace(/,/g, "") ). There's no way to get rid of the thousand separators, only of the decimals (like Hamid described).

  Rainer

  0

  Comment actions Permalink
• 

  Mark Cannon

  • February 11, 2016 18:05

  When I first saw this, I thought it was about how to filter on a calculation field. I didn't know it was possible to do that. I have several string calculations that I would like to filter on, but don't see them in my options for filtering when I click on the funnel for an app. How do I do that?

  Also, is it possible to filter on relationships?

  0

  Comment actions Permalink
• 

  Hamid

  • February 11, 2016 22:32

  Hi mark

  Calculation field must be a number type to filter it.

  It is not possible to filter a relationship field.

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • February 12, 2016 08:25

  Hi Mark,

  in app view you can filter via the funnel on calculation fields which are number type and date type (on string type it's not possible).

  On relationships you can filter if they are OUTGOING. 

  
  
  

  0

  Comment actions Permalink

Please sign in to leave a comment.