How do you get value of a cell in Google Spreadsheets, subtract 1 from it, and update that cell?

[Krishna_Goutham_N]

So, what the title says. I have a scenario which looks something like this:

In the 26th module (Google Sheets Search Rows), I’m searching for a row with a unique identifier (works correctly), and gets the value of that cell using Get a Cell module. Then, In the tools module, I’m using Set Variable, and then setting the variable to “Value - 1”.

However, this is returning a text “5-1”, instead of the value 4.

27.Value seems to not return a number properly (in the sheet, it should be number 1).

I think the Get a Cell module is return a text 5. How do I convert that/force that into numeric?

[CodexSolutions]

Hi @Krishna_Goutham_N

Please use
Sum function
sum(parsenumber(27.value) ; -1)

Thank you