How to enable Javascript

Latest Posts

Re: Populate dynamic values comma separator in same field Thanks, Amit. CASE worked. We are facing a new issue as the data is large Spark SQL is throwing an error is there any way we can achieve LISTAGG inside MV of spark python data frame.…
- Mehraj
- Starbucks
- burgundy_sail
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Populate dynamic values comma separator in same field @Amit Kothari /@Anurag Malik , Is there any way we can include the decode statement along with concat_ws.
- Mehraj
- Starbucks
- burgundy_sail
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Populate dynamic values comma separator in same field It worked. Thank you @Anurag Malik & @Amit Kothari
- Mehraj
- Starbucks
- burgundy_sail
- 6 mths ago
- Questions & Answers
- Reported - view
0
Populate dynamic values comma separator in same field
Hello, Is there any way in Incorta using In query to populate a list of results in one field with a comma separator? In the attached file provided the AS-IS where # of invoices are populated per…
- Mehraj
- Starbucks
- burgundy_sail
- 6 mths ago
- 6 replies
- 52
- Questions & Answers
Re: Total count/sum with greater than condition Hi Anurag, Thank you so much for detailed video. Solution works perfectly for our requirement. Really appreciate showing how to add dynamic variable. Have a great day! Thanks Mehraj
- Mehraj
- Starbucks
- burgundy_sail
- 11 mths ago
- Questions & Answers
- Reported - view
Re: Total count/sum with greater than condition @Anurag Malik Apologies may be screenshot was not showing the value but it is selected. Attaching word file with screenshots and a short recording to compare with & without aggregate filter results.
Attachments
- Mehraj
- Starbucks
- burgundy_sail
- 11 mths ago
- Questions & Answers
- Reported - view
Re: Total count/sum with greater than condition Hi Anurag, Thanks for prompt response. I tried aggregate filter but it does not affect the result shown. As the po# is a string with transaction number.…
Attachment
- Mehraj
- Starbucks
- burgundy_sail
- 11 mths ago
- Questions & Answers
- Reported - view
1
Total count/sum with greater than condition
We have requirement to get total Purchase order count & sum of Purchase order amount for only suppliers greater than 2 purchase orders. Can you please help achieve total count along with having…
- Mehraj
- Starbucks
- burgundy_sail
- 11 mths ago
- 7 replies
- 95
- 1
- Questions & Answers

Back to top

Mehraj

burgundy_sail

Starbucks

8
1
0

Follow