Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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]))
I believe you get enough answers from the post can you please close the threads with appropriate answers for persons for references.
Regards
Anand
thank you all for help.
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.