Do you have Problems with the SPSiteDataQuery (CAML) query of Sharepoint
computed Fields. You are running in an Error or recive an empty DataTable ?
Normaly you think your query must be correct because it looks exactly like this:
Haha, yes my friend, you are realy not alone with this problem on the planet.
It seems to be the logical solution for the correct caml querry,
but the value type is saved in the format it is determined
in the Computet Field, So is the field of the Type Text, or Integer ?
Than the query must look like this:
You can get the correct ValueType of the field with -> ((SPFieldCalculated)field).OutputType.ToString();
Please also note this. The Value defined for the coloumn has to match the ValueType that is expected with the formula !
For Example: The Result of (Column1+Column2) is interpreted by Sharepoint as Number
so the ValueType must be Number
For Example: The Result of =Concatanate([Column1][Column2]) is interpreted by Sharepoint as Text
so the ValueType must be Text