More than and Less than

[Anonymous]

I need to create one column that provides total more than $1.00

Another column when total are negative less than 1.00

[Gabriel]

Hi,

Even though the question is not completely clear, but I will attempt to answer your question.

You probably want to have something in the script like this

Data:

LOAD * INLINE [

    ID, Amount

    1, 1.2

    2, 100

    3, 2.1

    4, 0.9

    5, 0.6

    6, 0.7

    7, 80

    8, 90.5

];

LEFT join (Data)

LOAD

ID,

Amount            AS [Less Than 1]

Resident Data

WHERE Amount < 1;

LEFT join (Data)

LOAD

ID,

Amount            AS [Greater Than 1]

Resident Data

WHERE Amount > 1;

[trdandamudi]

The question is not clear, can you give some more details...

[Anonymous]

I am entering  =A-B  I receive a total Amount which is correct.  Issue  some values are Positive and Some are Negative.

I need two columns -  One I want to return all of the Positive Amounts and the 2nd to return all the Negative.

Example calculations in Excel  - Trying to produce the same results

=IF(J9-M9<1,J9-M9,0)

=IF(J8-M8>0,J8-M8,0)

.   

[ramoncova06 · Accepted solution]

COLUM 1

if(RANGESUM(A-B)) > 0, RANGESUM(A-B))

COLUMN 2

if(RANGESUM(A-B)) < 0, RANGESUM(A-B))

[MarcoWedel]

why is it an issue that some values are positive and others negative?

[MarcoWedel]

an alternative to using two expressions might be a calculated dimension and a single expression:

hope this helps

regards

Marco