If Then Calculation
I'm trying to do a simple calculation with a couple fields. I have the following setup
Total Points Field (Calculation field)
Split Field (Category Field, has two options Yes/No)
Agent Points (Calculation field)
I want to create another calculation field (Agent Points) that divides the Total Points Field by 2 or by 1 depending on whether the Split Field is Yes or No.
For example, if the Total Points Field = 1,000 and the Split Field is Yes then divided by 2, so the Agent Points will be 500 if not divided by 1
Thank you in advance!

In the field settings you can set how many decimals are shown in the item (0,2,4). But it seems your calculation field is text type so the result is text not a real number. Create a new calculation field and enter the code again. Then click the little triangle to the left of the field name and set it to 0 decimals.

Hi,
Want to enter a simple condition in calculation field in Podio:
IF(@Conversion="Yes";@Principal*@InterestRate*@YearFracConverted; @Principal*@InterestRate*@YearFracNOTConverted)
I've done the following in Podio:
var Converted = @Converted
var prin = @Principal
var int = @Interest Rate
var fracc = @YearFracConversion
var frac = @YearFracNotConvertedConverted ="Yes" ? (prin*int*fracc) : Converted="No" ? (prin*int*frac) : ""
But is always gives me the result of "Yes" and never of "No"
Thanks for the help!
Please sign in to leave a comment.
Comments
6 comments