Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
To be honest, I may be blind to the obvious, I tend to miss the obvious, especially as I'm new.
I have spreadsheets for two periods (December and April) of the same data (RateMe) for which I need to make % comparisons:
RateMe is a series of rating scores of one to five.
((Count([RateMe]))/(Count (total [RateMe])))
When I run this expression with Dimensions of Period and RateMe it totals the count for both periods rather than totally for each.
I have also just used
Count([RateMe])
And ticked 'Relative' on the expressions tab and 'Show in Percent' on the number tab, and it has the same effect.
How do I get a % Comparison between the values for these two periods?
Thanks
Yes proper combination of 'Relative' and 'Show is percent' is the key. Try expression:
=Count([RateMe]) / (Count (total [RateMe]) / 100 ,and check 'Show in Percent %' and uncheck 'Relative'
num(((If(Month='Apr'((Count([RateMe]))/(Count (total [RateMe]))))-If(Month='Dec'((Count([RateMe]))/(Count (total [RateMe]))))))
/If(Month='Dec'((Count([RateMe]))/(Count (total [RateMe])))),'#.##%')
hope this helps
This gives me the same issue I had initially. Sorry.
This gives me 'no data to display' and 'error in expression' 😕
try to solve error .ie somewhere ( missing or extra)
you can check for syntax error.
otherwise you can attached a sample
hope this helps
Hi
If I understand you correctly, then
=Count([RateMe]) / Count (total <Period> [RateMe])
should work. If not, I suggest that you post your qvw document here as the problem may lie in your data structure.
HTH
Jonathan