Hi,
I am new to QlikSense and trying the below formula to divide two fields and not able to get the correct answer.
num(sum({<$(VComparePeriod)>}"Sales")/Sum({<$(VComparePeriod)>}"No. of days"),'#.00%')
This formula gives same output/answer for all the days, weeks and months which does not match the pivot.
Tried the formula without variables as well, it throws an error.
Can someone please help?