After and Below functions

[#1]

I take in dimension Month and expression

(sum([sales]) - after(sum([sales]))) / after(sum([sales]))

but it's not working like this before is also not working

tell me some solusions

thanks and best regards

[#2]

HI

Can you share you application ..... and whats the problem please describe ???

[#3]

I want to compare SALES of present month to previous month (through after function)

[#4]

After function works like this

for example B : after(A)

Filed A : 1 2 3 4 5 6

Field B: 2 3 4 5 6 _

(sum(a) - sum(b) ) / sum (b)

I hope you want to calculate the same ??? but check before that your after function is working properly and values are coming on to it.

[#5]

Ya Like this but when i use the after function the value is not coming (null)

thanks and regard

[#6]

after function works on row wise .....

i think you should use Above() function for the same in your script.

(sum(A) - above(sum(A) ) / above(sum(A))

PLease let me know if it works ..... and if not i suggest u should share you application , i will make it for you 🙂