Answered

Condition built on calclulation

(0) Share

Report

Posted on by MarioOne

Say, I have a field A and B and I want to check is value in A is more than 20% of B. The result of this comparision I wanted to use a a condition for the remaining logic but I am failing to accomplish this task.

It seemed simple as COndition

- A/B: div(float(triggerOutputs()?['var_A']), float(triggerOutputs()?['var_B']))

- is less than div(float(triggerOutputs()?['var_QUOTE']), float(triggerOutputs()?['var_REMVAL'])) *0.2

This hwoever renders the result as:

Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

I have checked if that may be related to decimal sign, but whatever I use DOT or COMA it still does not work.

How to overcome this obstacle?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @MarioOne

Could you pls share the values of all those four variables used in the condition?

Thanks

Was this reply helpful? Yes No
MarioOne 67 on at

Like (0)

Report
Copy link

Link copied!

Hey Manish! Thank you for replay! I am having only two variables
and my Condition is:
Happy to hear from you! 🙂

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @MarioOne

Thanks for sharing the details with screenshot. You need to pass the variables in the div function but in your expression, you are passing those values from the trigger.

Pls try the below expression:

div(variables('var_QUOTE'), variables('var_REMVAL'))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
MarioOne 67 on at

Like (0)

Report
Copy link

Link copied!

It seem to work perforctly! When I used it initially without having variables created it failed - now, all seem to work perfectly. Thank you so much - Appreciate your help 🙂

Was this reply helpful? Yes No