- Posts: 725
- Thank you received: 15
Report summar
- hanisultan
-
Topic Author
- Offline
- Platinum Member
-
Less
More
10 years 4 months ago #7219
by hanisultan
Report summar was created by hanisultan
So I want to get a summary on a field but with consideration to another field
so like I want to sum of volumes for dealer age = 'New'
[SUM(<UniDACQuery."volume"> <UniDACQuery."dealer_age"> = 'New',MasterData1)] I know this is not correct but what is the correct way if it is possible?
so like I want to sum of volumes for dealer age = 'New'
[SUM(<UniDACQuery."volume"> <UniDACQuery."dealer_age"> = 'New',MasterData1)] I know this is not correct but what is the correct way if it is possible?
Please Log in or Create an account to join the conversation.
10 years 4 months ago #7228
by admin
Mike
ETL Architect
Replied by admin on topic Report summar
This one works
[SUM(IIF(<ADOQuery."CountryId">=10,1,0),MasterData1)]
Mike
[SUM(IIF(<ADOQuery."CountryId">=10,1,0),MasterData1)]
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
- hanisultan
-
Topic Author
- Offline
- Platinum Member
-
Less
More
- Posts: 725
- Thank you received: 15
10 years 4 months ago #7234
by hanisultan
Replied by hanisultan on topic Report summar
Worked perfectly, thank you
Please Log in or Create an account to join the conversation.