Skip to Content
0
Former Member
Jan 21, 2009 at 02:59 PM

Variance Formula: Cost of Service between 2 years

203 Views

Good day everyone,

I am using BOXI r2 sp 4.

The following variance formula will ONLY work if the client selects the time frame of 1 year. For example 2008-01 to 2008-12

=<Cost of Service>Where{<Billing Year Month>=UserResponse{Enter Billing Year Month Start:"} - <Cost of Service>Where{<Billing Year Month>=UserResponse{Enter Billing Year Month End:"}

PROBLEM: the client must select 2 years For example 2007-01 to 2008-12

But none of my formulas work.

=<Cost of Service>Where{<[Billing Year Month>=UserResponse{"Enter Billing Year Month End:"}}-<Cost of Service>Where{RelativeDate{<Billing Year Month>;-365}}}

or

=<Cost of Service>Where{<Billing Year Month>=UserResponse{"Enter Billing Year Month End:"}}-<Cost of Service>Where{RelativeDate{<Billing Year Month>;-365)=UserResponse{"Enter Billing Year Month End:"}}

or

=<Cost of Service>Where{<Billing Year Month>=UserResponse{"Enter Billing Year Month End:"}}-<Cost of Service>Where{<Billing Year Month>=UserResponse{"Enter Billing Year Month End:"}}Where{RelativeDate{<Billing Year Month.;-365}}

Someone please put me out of my misery.

Wannetta