I have the following:
Month Subtotal
District year quarter Days Sum(Days)
Crewsize First(Cresize)
Example:
1 2 3 Subtotal
GP 2007 FirstQuarter Days 101...
How can we get days in a month, if the month number is given. I need a function as below:
DaysInAMonth(MonthNumber) = NumberofDaysInMonthNumber
Thank you,
I have the following crosstab:
--------------Month------
District Year Quarter 1 2 3 Total
XX 2007 FirstQuarter 6.2 6.1 5.6 Avg(6.2,6.1,5.6)
YY 2007 FirstQuarter 1.1 1.3 0.4 Avg(1.1,1.3,0.4)...
The formula in the format field - Display string in a crosstab is:
stringVar Result;
Numbervar AfterDistribution;
whileprintingrecords;
AfterDistribution:= currentfieldvalue - val({@DistributionAmount});
Result:= TRIM(totext(currentfieldvalue,1))+ CHR(13) +TRIM(totext(AfterDistribution,1))...
I have a crosstab as follows:
SUMMARY FIELD = Operatingdays
year
Quarter
Month
district1 district2 total
unit1 1 2 3
unit2 14 1 15
Total 15 3 18
I created two groups in the report. 1. By...
Does anyone know how the FIFO value, Qty on hand on the Historical Stock Status is calculated? This is very important for me to know.
I appreciate if anybody could share their knowledge.
Thank you for your help in advance,
dhv919401
Does anybody know what the field UMQTYINB in POP10110 (Purchase Order Line Detail table) contains? Is this the number outstanding either to be invoiced?
Thank you for your help in advance
dhv919401
On a purchase order all the items are received except one item. The line item status is released. I want to cancel this purchase order line item. When I enter the quanity in the canceled qty and save it, it saves the PO. But it is not retaining the changes and canceling that item. How do I...
Hi I have a FRx report which has one tree, one row format.
This is a departmental report. In the tree there is a consolidated line which is not associated with any row format. I have other departments under the consolidated line in the tree. When I run the report for individual lines, there is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.