[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

Len of many fields & add them up

is there a way take fields in my report, figure out the Len() of them, then add them all to gether to get the total number of characters for those fields.

For Example:
len(trade.settle) + len(trade.maturity) + len(trade.days) +len (trade.name) + len(trade.address) + etc = total characters
0
IO_Dork
Asked:
IO_Dork
  • 2
1 Solution
 
mlmccCommented:
Exactly like that

Create a formula
Name - TotalLength
Length({Trade.Settle}) + Length({trade.maturity}) + Length({trade.days}) + ...

mlmcc
0
 
IO_DorkAuthor Commented:
I tried that, but got an error..."expects string"
0
 
IO_DorkAuthor Commented:
it worked...I was trying to use the function len() instead of length().  Thanks!
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now