Skip to Content
0
Former Member
Nov 14, 2008 at 03:25 PM

Calculating Variance (Difference)Based on Dynamic Billing Year Month Object

90 Views

Hi folks,

I need to calculate the difference in the cost of service based upon billing year month which is dynamic. I tried to execute the formulas but it didn't work.

$ = Cost of Service

BYM = Billing Year Month

=$ Where BYM ="UserResponse("Billing Year Month1:") - $ Where BYM="UserResponse("Billing Year Month2:")

or

=$ Where Billing%20Year%20Month1:="UserResponse("Billing Year Month1:")-$ Where Billing%20Year%20Month2:="UserResponse("Billing Year Month2:")

sighs

Can someone help me?

Thanks,

W.

Edited by: Wannetta Thomas on Nov 14, 2008 4:25 PM

Edited by: Wannetta Thomas on Nov 14, 2008 4:26 PM

Edited by: Wannetta Thomas on Nov 14, 2008 4:48 PM