Forum Discussion
Advocate IINeed Help in grouping by value in a calculated table
Hi,
I am trying to group unique invoices by their bill value. I tried the below formula but something doesnt seem to work & I am getting an error "Argument '16' in SWITCH function is required."
Hi AmeenVanakar
I believe you simply need to remove the final comma after "Above 10000", in the line ''Unique Bill Number'[Bill Value]>10000, "Above 10000",'.
That final comma makes the switch statement believe that more arguments are coming.
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data
3 Replies
- Kedar_Pande
Super User
Corrected formula
Bill Range =
SWITCH(
TRUE(),
'Unique Bill Number'[Bill Value] <= 1000, "Below 1000",
'Unique Bill Number'[Bill Value] > 1000 && 'Unique Bill Number'[Bill Value] < 2000, "1001 - 2000",
'Unique Bill Number'[Bill Value] > 2000 && 'Unique Bill Number'[Bill Value] < 3000, "2001 - 3000",
'Unique Bill Number'[Bill Value] > 3000 && 'Unique Bill Number'[Bill Value] < 4000, "3001 - 4000",
'Unique Bill Number'[Bill Value] > 4000 && 'Unique Bill Number'[Bill Value] < 5000, "4001 - 5000",
'Unique Bill Number'[Bill Value] > 5000 && 'Unique Bill Number'[Bill Value] < 10000, "5001 - 10000",
'Unique Bill Number'[Bill Value] > 10000, "Above 10000",
"Unknown" // Default value if none of the conditions are met
)
If this helped, a Kudos 👍 or Solution mark would be great!
Cheers,
Kedar Pande
www.linkedin.com/in/kedar-pande - Jonvoge
Most Valuable Professional
Hi AmeenVanakar
I believe you simply need to remove the final comma after "Above 10000", in the line ''Unique Bill Number'[Bill Value]>10000, "Above 10000",'.
That final comma makes the switch statement believe that more arguments are coming.
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data
AmeenVanakarProblem solved! Thanks Jonvoge
