Subracting the Values in 2 Strings in an ADF Expression

Question

Hello! This one stumped me. @Nasreen Akter @MartinJaffer-MSFT

I have one String that is say 40
Then I need another String that is 100-40 = 60
The first String which is equal to 40 is stored in the DB Table as an nvarchar(max)

I tried :
@sub (100,variables('VirtualHours'))

but I get: Expression of type: 'Int' does not match the field: 'value'

Any suggestions?

Thanks
Mike Kiser

Answer 1

Hi @Mike Kiser ,

Thanks for reaching out.

As per your description, I assume your variable variables('VirtualHours') is a string type , if that is the case then please try --> @sub(100, int(variables('VirtualHours'))).
As the function sub expects its parameters to be an integer or a decimal number, you will have to convert the parameter value of type String to int.

In case if you are storing/assigning the output of this expression to a string type variable/parameter then please try this expression --> @string(sub(100, int(variables('VirtualHours')))).

Hope this helps. Do let us know how it goes.

Thanks

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

Hi @Mike Kiser ,

If you are using the expression in your IF Condition activity, please try this --> @greater(sub(100, int(variables('VirtualHours'))), 0)

Do let us know how it goes.

Thank you

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.