Hi there,
I use the SAP field - LQUA.LENUM.
Example of the content in the detail section:
1000003740
1000003741
1000003953
I want the result on my group section.
But when I try...
nthsmallest (1, {LQUA.LENUM}) - I get 1000003740
n...
Hello,
to get the sales amount of the previous month I use the following simple formula in one of my reports
if (month({S511.SPTAG}) = month(currentdate)-1) AND (year({S511.SPTAG}) = year(currentdate))then {S511.ZUMKZWI3}else 0;
I was wonder...
Hi,
I use the item consumption for the last months in multiple reports but have to edit every report with the beginning of the new month so it would pull again the last 12 months consumption.
Im looking for a way to have that updated without me e...
Hi.
I have the following issue:
I have Items with StorageNumbers. The same item can be in different storage locations.
I set "Item" as a group and the column ST# won't be visible later.
ST#1 shows the lowest number in the group ...
Hi there,I created a Report with a group that's called "Produktsegment". Example:ProduktsegmentProduktgruppeUmsatzMaterial0120500Material0130600Material0140400Prothetik10206Prothetik10305Orthetik20304Orthetik20402I do not need the group name to show ...
I actually just found the solutionI used a running totalname=LE#2field to summarize LQUA.LENUMtype = minimumevaluate = used the formular option LQUA.LENUM<>Minimum({LQUA.LENUM},...)reset = by change of groupplaced in group footer and checked a few da...
yes it does, but I thought since It finds the smallest and the largest with the nth position why not the middle one as the 2nd largest ? It doesn't make any sense (to me at least)Jacky
Hi Abhilash,Im sorry for the late reply but I wanted to test your ideas before I give feedback and just were out of town for a few days.Thank you very much for all your help. This will actually save me a lot of time in the beginning of every month - ...
