topic Re: Subtract two variables in App Development

Subtract two variables

jerryr125 — Thu, 15 Apr 2021 14:23:35 GMT

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 ?

GaryGiles — Thu, 15 Apr 2021 19:26:20 GMT

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)))

jerryr125 — Thu, 15 Apr 2021 21:43:55 GMT

HI - The below works - thanks for your guidance:

=SUM(($(=vBDGT)))-SUM(($(=vACT)))