Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Month-1 & Only(Month)-1

if Month-1 & Only(Month)-1 gives same output then why we required Only function.

Unable to understand. Please help on this.

3 Replies
Anil_Babu_Samineni

Assume, If you want to show only single year of month

Only({<Year = {'2016'}>}Month)-1 // it will give only 2016 months.


How to use - Only()

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

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

avinashelite

Check this Doc

How to use - Only()

Use of ONLY Function

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