Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
SUM(IF(GROSSTOT >= 1000, GROSSTOT))
or
IF(SUM(GROSSTOT) >= 1000, SUM(GROSSTOT))
First one can be converted to this -> I love making it complicated
Sum(RangeMax(GROSSTOT-1000, 0)+1000)
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
I really wanted it to work
Oh well!!!
Never mind. Nice trick anyway ...
Hahahahaha
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))
Hi stalwar1,
nice one.
Sum(-(GROSSTOT>=1000)*GROSSTOT)
also should deliver the same result (except for negative GROSSTOTS)