question

ReddyReddy-9030 avatar image
0 Votes"
ReddyReddy-9030 asked KamleshKumar commented

Sum amount based on date

Hi . I have an issue in writing the query for below scenario
CompanyA. Sep 2021. 45000rupees
CompanyA. Jan 2021. 3300rupees

CompanyB. March 2021. 5000rupees

CompanyB. Jan 2021. 6000rupees

Now I need to find the company amount as different if the date is more 6 months . If not sum the amount and show as 1 row

biztalk-server
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi There,

Thank you for asking this question on the Microsoft Q&A Platform.

We would need more details about your issue, what steps did you try and what is not working, if you can provide more details to understand your issue and accordingly we'll help you to resolve it.

I would suggest to use the XSLT and grouping there, that would solve your question.

Please share what you tried so we'll let you know the correct approach.

Regards,
Kamlesh Kumar

If this answer solved your problem, please click the Verify Answer button (found below the answer) to help other users who have the same question.

0 Votes 0 ·

0 Answers