When working in a Membership query, the field Membership Transaction\Revenue Application\Amount will pull blank if the membership level amount is defined as $0.00 within your membership program. If the Membership level has a cost associated with it, and a 100% membership promotion is applied to the membership the field will pull as $0.00 rather than pulling a blank amount.