above 1000 value

[sagaraperera]

Dear ALL

I HAVE VALUE EXPRESSION NAME OF GROSSTOT IT HAVE BEEN RS. 1 TO UN LIMITED VALUE BUT I WANT TO GET VALUE ABOVE RS.1000 VALUE. PLEASE HELP ME

I USE GIVEN BELOW

Sum (GROSSTOT)

BUT IT HAVE ALL VALUE , BUT I WANT TO GET VALUE ABOVE RS.1000 VALUE. PLEASE HELP ME

SAGARA

[MK_QSL]

SUM(IF(GROSSTOT >= 1000, GROSSTOT))

or

IF(SUM(GROSSTOT) >= 1000, SUM(GROSSTOT))

[sunny_talwar]

First one can be converted to this -> I love making it complicated

Sum(RangeMax(GROSSTOT-1000, 0)+1000)

[MarcoWedel]

Hi,

other expressions could be:

Sum({$<GROSSTOT={">=1000"}>} GROSSTOT)

Sum({$<Category={"=Sum(GROSSTOT)>=1000"}>} GROSSTOT)

one example including other proposed solutions:

maybe you could just use dimension limits instead?

hope this helps

regards

Marco

[sunny_talwar]

I really wanted it to work

Oh well!!!

[MarcoWedel]

Never mind. Nice trick anyway ...

[sunny_talwar]

Hahahahaha

[sunny_talwar]

marcowedel‌

This one seems to work

Sum(GROSSTOT*RangeMin(Floor(GROSSTOT/1000), 1))

Gives the same result as

Sum({$<GROSSTOT={">=1000"}>} GROSSTOT)

and

SUM(IF(GROSSTOT >= 1000, GROSSTOT))

[MarcoWedel]

Hi stalwar1‌,

nice one.

Sum(-(GROSSTOT>=1000)*GROSSTOT)

also should deliver the same result (except for negative GROSSTOTS)