Wednesday, March 7, 2012

Provision Calculated Fields with Formula

This will be a short note.

I had an issue as always when I try to make something  in Visual Studio. Today it was the first time I had to create calculated field using less than and greater than. And I'm not the most experienced one when it comes to setting up the XML, and it went bad.

I was stuck on how to get the "<" and ">" symbols in.

I could not find any information about it, then I started to think about HTML and entity names. And of course that was the solution, &lt; and &gt;

<Formula>=IF([RisikoRisikofaktor]&lt;0,"Green",IF([RisikoRisikofaktor]&gt;14,"Red","Amber"))</Formula>


No comments:

Post a Comment