Report summar

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?

Please Log in or Create an account to join the conversation.

More
10 years 4 months ago #7228 by admin
Replied by admin on topic Report summar
This one works

[SUM(IIF(<ADOQuery."CountryId">=10,1,0),MasterData1)]

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
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.