May i know what is wrong with the below formula.
Could some on help in correcting it.
if [TotalValueOfPotentialSale]<"100000" then "1. < 100k" elseif [TotalValueOfPotentialSale]>="1000000" then "5.=or>1 Million" elseif [TotalValueOfPotentialSale]>="100000" AND [TotalValueOfPotentialSale]<"250000" then "2.100k-<250k" elseif [TotalValueOfPotentialSale]>= "250000" AND [TotalValueOfPotentialSale]<"500000" then "3.250k-<500k" elseif [TotalValueOfPotentialSale]>= "500000" AND [TotalValueOfPotentialSale]<"1000000" then "4.500k- < 1 Million" else ""
endif
Solved! Go to Solution.
Check the Data type of 'TotalvalueofP....' change from string to integer. also check remove "" Quotes from the number. Please refer the formula below.
if [TotalValueOfPotentialSale]<100000 then "1. < 100k"