Table View

Follow

Phong To

• September 18, 2017 15:50

I have a relationship table with rates, see attached 1.  I'd like to display the rates in the referenced app as a table, see attached 2.  What's the best way to do so.

Attachment 1: 

Attachment 2: 

 

0

• 

  Hamid

  • September 19, 2017 08:58

  Hi,

  Try with this MARKDOWN code in a calculations field

  
  
  "  | Daily Rate | spread pbs | Par Rate" + "\n" + "--- | --- | --- | ---" + "\n" + "FNMA30 |" + @FNMA30 daily rate + " | " + @FNMA30 spread pbs + " | " + @FNMA30 Par Rate + "\n" + "FNMA15 |" + @FNMA15 daily rate + " | " + @FNMA15 spread pbs + " | " + @FNMA15 Par Rate + "\n" + "GNMA 2 30 |" + @GNMA 2 30 daily rate + " | " + @GNMA 2 30 spread pbs + " | " + @GNMA 2 30 Par Rate

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • September 19, 2017 15:37

  Hi Phong To,

  in the referenced app (let's call it app2): Is there only one item related from app1 (the app in your first attachment)?

  Rainer

  0

  Comment actions Permalink
• 

  Phong To

  • September 19, 2017 18:25

  Yes Rainer, only 1to1 relationship.  

  0

  Comment actions Permalink
• 

  Phong To

  • September 19, 2017 19:08

  Thanks Hamid, tried your code and it worked.  Thanks!

  1

  Comment actions Permalink

Please sign in to leave a comment.