Hello. I am trying to figure out the Deluge Script in Zoho Creator. The result I am trying to generate is this:
Through inputting, these variables are defined.
vs (this is a percentage)
Week_Gross (this is a decimal generated through a formula by adding several previously inputted numbers)
Guarantee (this is an integer)
In plain speak, the result I want is
If vs * Week_Gross is greater than Guarantee, then output vs * Week_Gross, otherwise output Guarantee.
I have generated the following script, but it doesn't generate correctly.
If((input.vs*input.Week_Gross)>input.Week_Gross,(input.vs*input.Week_Gross),input.Guarantee)
Can you advise?
Because Week_Gross is a formula already generated by adding several previously inputted numbers, do I need to put those in on their own instead?