Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if Month-1 & Only(Month)-1 gives same output then why we required Only function.
Unable to understand. Please help on this.
Assume, If you want to show only single year of month
Only({<Year = {'2016'}>}Month)-1 // it will give only 2016 months.
At time we need to use set analysis and you cannot use set analysis without a function. So, in those cases where you need to use set analysis (for instance you want to ignore selection in field A1, Only({<A1>} Month) - 1), you will need to use Only() rather then just the field name by itself
Check this Doc
Only will return if the dim has a single value in it ..other than that
Month-1 // we cannot implement the set analysis
Only({<>}Month)-1 // we can implement the set analysis