Search results for query: *

I am trying to sum a field, but i only want the sum of the visible selection. help please.

I need to figure a formula to give me currentdate from 6am to currentdate-1 6am. any help is appreciated

IF ISNULL ({INVENTRY.IssueUnitOfMeasure}) THEN {TRANS.quantity} ELSE {TRANS.quantity}*.3048 my problem is this, i only need {TRANS.quantity} to multiply by .3048 if the ({INVENTRY.IssueUnitOfMeasure}) is = MT otherwise i need it to just be {TRANS.quantity}. Any help here would be greatly...

my formula reads like this but i need to group by this formula and it does not show up to group by it. if GroupName ({oe_line_1000.budget_code}) startswith "P" then left(GroupName ({oe_line_1000.budget_code}),5) else left(GroupName ({oe_line_1000.budget_code}),4)

i am trying to make a formula to display correctly. What i need is this {@Budget4}#{@Budget1} which should display the data example 043#0017. I am having trouble getting the # in between in the formula. I do not want to do a text field that has the "formula # formula". I need a separate...

I have the Details section set to suppress for the following. Problem is that if i have only one i works. That is either or, but if i combine both of these formulas neither work. Where ami going wrong because the formulas show no errors when i check thm. {p21_view_inv_xref.delete_flag} = 'Y'...

here is the formula i am using IF ISNULL ({p21_view_inv_xref.delete_flag}) OR {p21_view_inv_xref.delete_flag} = 'N' THEN {invoice_line.extended_price} ELSE 0 this works great as a sum total, but in my details section it shows them with a Y or a N. I need for it to not show those with a...

Some help would be extremely appreciated. Her is the formula i have (1 - (Maximum ({invoice_line.unit_price}, {invoice_line.item_id}) / {p21_view_inv_xref.last_price_paid})) * 100

I have a field that has 8 numeric characters in it. I use a formula to remove the last four. I need to group those first four onto one line with the sum of all with those first four. As an example you have 42000000 $10 42000001 $20 42000002 $30 42010000 $10 42010001 $20 42010002 $30 i am...