Set analysis - division

[qliktech_uk]

Hi,

If I have to calculate sum(x)/sum(y) for the latest month in a text box would I have to do it this way

sum({<[Month ] = {'$(VMaxMonth)'}>}x) /sum({<[Month ] = {'$(VMaxMonth)'}>}y)

[sunny_talwar]

Are you doing this in a table where Month is a dimension? If this is true, then try this

Sum([Sent Files])/Above(Sum({<Month>}[Sent Files]))

[its_anandrjs]

I believe you get enough answers from the post can you please close the threads with appropriate answers for persons for references.

Regards

Anand

[qliktech_uk]

thank you all for help.

[its_anandrjs]

In Month field what type of data you have kind check it seems NumMonth work here because Max(Month)) gives you numeric values kindly check this.