values are changing if i copy the same formula in nprinting

[srujanaponnuru]

Hi,

I have written one formula in QlikSense in a text object and i am getting correct value. But the same formula if i copy paste in Nprinting formulas section, the value is changing . Could u please help. 

code i have written as below:

sum({<Metric1={'123'}, Date = {'$(=$(vMTD))'}>}sales)-
sum({<Metric1={'123'}, Date = {'$(=$(vPMTD))'}>}sales))

[MayilVahanan · Accepted solution]

HI @srujanaponnuru 

Is that values are changing in the Nprinting for these 2 variables (vMTD & vMPTD)?? In that case, values will be different.

[srujanaponnuru]

Hi Mayil,

I havent checked the values of those two variables because when i am pulling those variables separately from NPrinting to excel, result is showing as full formula. I am not getting the value of that variable in the result. how to put a variable then ?