Forum Discussion

Marco's avatar
Marco
Contributor II
4 months ago

subtract the value of one column with another in a CV

Hi Everyone.

I want to perform a subtraction of columns 1 and 2, I did it with the code below, but I see that it affects my performance too much, so I would like to know what other option I can do to do something like this without affecting the performance too much, I added that it waits 600 seconds but it still takes too much time.

GetDataCell(T#WFYear-|!PLN_ParamNextFcstYear!|):Name(test)

(I am subtracting the current year's values from the next year's values.)

  • Hello,

    I would typically use GetDataCell(CVC(Col1) - CVC(Col2)):name(test) . Please try like this and let us know if that fits your requirement.

    Regards,

  • Sergey's avatar
    Sergey
    Contributor III

    Hello,

    I would typically use GetDataCell(CVC(Col1) - CVC(Col2)):name(test) . Please try like this and let us know if that fits your requirement.

    Regards,