Hi All,
Scenario:- I have some students record, with marks of 5 subject & I want to calculate total marks & percentage & to update in excel again.
I am moving my data from an excel to collection & then collection to a Work Queue.
So the Output of "Get Next Item" is stored in the Collection "Data"
But in the Calculation stage(Expression: [Data.English]+[Data.Hindi]+[Data.Math]), when I am trying to add marks in different subject, I am getting below error:-
"Internal : Failed to evaluate expression '[Data.English]+[Data.Hindi]+[Data.Math]' - Can't add to Text"
I am not sure why the Number Data types are getting pulled as Text
Please advise.
Thanks
Scenario:- I have some students record, with marks of 5 subject & I want to calculate total marks & percentage & to update in excel again.
I am moving my data from an excel to collection & then collection to a Work Queue.
So the Output of "Get Next Item" is stored in the Collection "Data"
But in the Calculation stage(Expression: [Data.English]+[Data.Hindi]+[Data.Math]), when I am trying to add marks in different subject, I am getting below error:-
"Internal : Failed to evaluate expression '[Data.English]+[Data.Hindi]+[Data.Math]' - Can't add to Text"
I am not sure why the Number Data types are getting pulled as Text
Please advise.
Thanks