ComputedColumn

is there any way to have a if condition statement in computed column,
if not? how can I have group band on a Formula field ?

Comments

  • edited 11:24AM
    Hello,

    You can use "?" statement in the column's Expression:

    [Table1.Column1] == "A" ? "Alpha" : "Beta"

    Do you need to sort a band on custom condition? Just open the databand editor and put this condition in the "Sort by" textbox, for example

    [Table1.Name].Substring(0,1)

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.