These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Topic Options
#57446 - 03/11/20 12:13 PM Subtraction inside of an IF funtion
Uriah Offline
OL Newbie

Registered: 03/11/20
Posts: 1
I am trying to subtract 2 different variable fields based on the input of a 3rd variable field. Something like this…

If([Ded_1_Description] = “Y” , Val([Ded_1_Annual_Price])-Val([Transaction_Fee_Month]) , “Free”)

But i cannot get the sting to populate. I can get the subtraction to function without the IF statement but once i place it into the IF statement i get an error.

Any help would be appreciated.

#57447 - 03/11/20 12:40 PM Re: Subtraction inside of an IF funtion [Re: Uriah]
Jean-Cédric Offline
OL Expert

Registered: 10/03/16
Posts: 681
Loc: Québec, Canada
I think you need to reconvert your resulting result for true into a string.
99 frigging bugs in my code
99 frigging bugs
Take one down
Code around
127 frigging bugs in my code