Inconsistant Datatyp in Formula

User Talk Formulas
1

Hi,
we have the following columns:

  • sales (Formula value with numbers)
  • discount % (Numbers, format %)
  • discountvalue (Numbers, Euro)
    and we want to perform a calculation in a new column.
    If discount % has been entered, then “sales-(sales*Discount-%)”.
    If discountvalue was used, then "sales-discountvalue).

We use these formula
if({discount-%}=‘’,({sales}-{discountvalue}),(sales-({sales}*{discount-%})))

But we always get the error message “Inconsistent data type”.

Bye Thomas

2

Sales is the value in Euro ?

And is the disount in % not equal to the value?

3

So you want to have some kind of calculation if the discont in % is higher than 0 ?

4

Does

and

return results or errors?

If yes, the problem is in the conditional statement. If not, you know where to look.

Generally, if a cell is not empty and you refer to it, the return value is true. Hence, {column_name} returns true if the cell is not empty.

5

Does this work?

if({discount-%}>0, ({sales}-{discountvalue}),(sales-({sales}*{discount-%})))

6

the problem was the condition inside the if clause. With “{discount-%} = ‘’, …” the errormessage happens.
With the “if({discount-%} > 0, …” it works.
Tnx for your help

1 Like
7

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.