Design reports: formula for "Right" side of a cell

Brian Hammond

Hi Board Community:

I'm designing a report. I have a column of info that has a code like this: 1021981.001.002.003. We call this entity "Subworkplan."

I want to create a formula (or algorithm?) that will show me the right 11 cells, of what is in this column. For example, show me 001.002.003 in the above example.

In the "layout" section, I know how to click a + button and select "Add Algorithm," but I don't know what I would type in for an algorithm that would produce the right 11 cells of what is in the "Subworkplan" entity. I would know how to do it in Excel, but not in Board.

Can anyone please help?

Thanks!

------------------------------
Brian Hammond
Administrative Analyst III
County of San Diego
United States
------------------------------

Helmut Heimann

Dear @Brian Hammond,

if you know how to do it in Excel, you know how to do it in Board as well.
Your Algorithm should read "right(a,11)" to display the right 11 cells of block a.

Be sure to define the output of the algorithm as "text".

That should do the trick.

Kind Regards,
Helmut

------------------------------
Helmut Heimann
Senior Consultant
Board Community
Germany
------------------------------
-------------------------------------------