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