CalculateColumns exemple

Hi, could you give me a proper exemple of how to use the CalculateColumns function for a dataset ?

I got S as a dataset
I want to add an offset to all y-data of that dataset.. I tried that, based on the helpfile, but it didn’t work…
[code]Formule (as string) = “x + ” & offset
S.CalculateColumns Formule, fpDataComponentY[/code]

Also, I want to select just a small part of my entire dataset. I tried that code :
[code]Formule = x[[StartTime, EndTime]]
S.CalculateColumns Formule, fpDataComponentAll[/code]

Both method are working fine in FScript… I tought CalculateColumns method was the same as FScript.

This is exactly what I did! I tried again and it works only when the dataset “S” is in the rootfolder. If I select a dataset in another folder, I can’t make it work. I get the message : “Invalid procedure call or argument”
Here is my code :[code] Dim oDataset As DataSet
Dim str As String

Set oDataset = ActiveDatabase.ActiveFolder.Object(“S”, fpObjectTypeDataSet)
str = oDataset.FullName ‘Here I check if the correct dataset is selected
str = “x + 5”
oDataset.CalculateColumns str, fpDataComponentY[/code]
This code work fine when S is in the rootfolder, but it doesn’t when S is in a folder (but I checked that the dataset is well selected)

I’m confused…