topic Summing the prior month in QlikView

Summing the prior month

Fri, 27 Nov 2009 20:43:37 GMT

The syntax here for summing the records for the previous month is not working.

Any suggestions on the correct syntax

=Sum ({$<[Period (FDPERD)]={"=(only([Period (FDPERD)]))-1"}>}[TR Outstanding (TROUTV)])

Thank you

Fri, 27 Nov 2009 20:58:06 GMT

You could try:

sum( {$<Period= {"$(=Num(Period-1))"}>} [TR Outstanding (TROUTV)])

Fri, 27 Nov 2009 21:34:45 GMT

I have 2 suggestions for you:

sum( {$<[Period (FDPERD)] = {$(=Only([Period (FDPERD)])-1)}>} [TR Outstanding (TROUTV)])

sum( {$<[Period (FDPERD)] = {$(#=Only([Period (FDPERD)])-1)}>} [TR Outstanding (TROUTV)])

Hope these work!

Best,

Maya