Tagged with if_statements - Visokio Forums

Formulae: bracketing values using IF logic?

kantia8 — Wed, 05 Nov 2014 17:36:21 -0500

I am trying to do an analysis where I want to rename variables if they are between at set of numbers
i.e.: if the value of [Field1] is >10 and <20, then the value is changed to something like "Page2" in the [Formula Field1]

I know how to use the operators "=", ">" and "<", but I don't know how to do in between. I looked at the bucket function, but that seems to only work for dates and not other field types?

Formulae: Two conditions in an IF statement using AND?

amitbdesai — Mon, 19 Aug 2013 16:21:41 -0400

If have two condition called [TotalCommission] and [TotalSales].
I want to put two condtions on these values like [TotalCommission]>0 and [TotalSales]>0 in IF statement.
How can I do this question becausI am placing "AND" between this two statement but this does not work.

My current formula looks like:

IF(([GrossTotalCommission]>0 AND [GrossTotalSales]>0),([GrossTotalCommission]/[GrossTotalSales]),(SUM([CJTotalCommission]+[PPJTotalCommission]+[IRTotalFee]+[AdditionalFeeVertive]+[AdditionalFeeDarren])/([CJOrders]+[IROrders]+[PPJOrders]))

EWhat can I add or improve to this statement to get result?

Any help appreciate. Thanks a lot in advance.
Amit

Formulae: Conditional values?

amitbdesai — Fri, 09 Aug 2013 12:30:30 -0400

I have table where in one column [Call conversion] is coming from one condition.

Now the condition is like:
If Sales > 0 then I want to could leads based on sales value.
The resulting values will be inserted in [Leads] column.
Basically, how to put condition to get desired value or column?

I hope this information is enough for you and if you need more specific or something else just let me know so i can provide to ASAP. Thanks in advance for your help.

Formulae: Use value as a parameter?

MartijnVisser — Wed, 09 Jan 2013 08:01:16 -0500

Hello - I have a dataset which is similar to this:

Amount | Condition | Result
145000 | <150000 | 0,30
145000 | >150000 | 0,20

I'm trying to achieve the following IF statement:

IF(
Amount < 150000, Amount * Result
Amount > 150000, (Amount-150000) * Result
0
)

Is it possible to declare/use the value in the condition field as a a condition in the IF statement?

Best, Martijn

Formula IF() with Null Values in text field

Focus_Media — Thu, 06 Oct 2011 12:44:50 -0400

I have a calculated field, and worked fine until I installed last version: 2.6 787(rc)

Steps to reproduce:

Create on new iok with 3 text fields: (Original, ChangedByUser, Formula)

Change field Formula and define this formula:
=IF(ChangedByUser="", Original, ChangedByUser)

If I write some text in the Original column, it should be shown in the Formula Field.

This worked fine until I installed yesterday last version.

Now, the condition (ChangedByUser="") ==> Is always False!!!

I think there are a little bit problem with Null/Empty values in a text field.

Because I didn't find a 'function' like IsNull(Value), i had to change the formula to:

=IF(("" & ChangedByUser)="", Original, ChangedByUser)

And then, it works fine... but I need to change a lot of formulas like this!

I think should be a 'function' IsNull(value) or IsEmpty(value), to avoid this problem.

Regards

Value Banding

bfromson — Fri, 03 Jul 2009 11:05:02 -0400

We have a frequent requirement to translate numeric ranges into banded value categories. If the bands are linearly spaced then this can be done easily using aggregations and histogram ranges, unfortunately if the bands are non linear (i.e 0 or belas one category, linear to an upper limit, then greater than the upper limit) it becomes tricky.

This can be solved inelegantly with a formula field and a lot of nested if functions. It would be useful to have some form of case statement/function that would make this more elegant.