Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - I have the following two variables created :
vACT
IF([FINANCEACTBDGYEAR]=$(vBudget_current_year),IF([FINANCEACTBDGMONTH]=$(vBudget_current_month_num),NUM([ACTUALAMOUNT],'0')))
** Works Perfect
vBDGT
IF([FINANCEACTBDGYEAR]=$(vBudget_current_year),IF([FINANCEACTBDGMONTH]=$(vBudget_current_month_num),NUM([BUDGETAMOUNT],'0')))
** Works Perfect
I created a new variable (the variance of the two)
vACTBUDVAR
=SUM((vACT)-(vBDGT))
does not work - results in zero - any thoughts ?
HI - The below works - thanks for your guidance:
=SUM(($(=vBDGT)))-SUM(($(=vACT)))
I think you need to add the $() expansion:
=SUM(($(vACT))-($(vBDGT)))
You may need to add an = sign to your 2 variables or the within the $():
=SUM(($(=vACT))-($(=vBDGT)))
HI - The below works - thanks for your guidance:
=SUM(($(=vBDGT)))-SUM(($(=vACT)))