Grouping Formula 1

[dannyb29]

Good Afternoon Everyone.

I am trying to create a formula which is based on a group on my report. The formula doesn't generate any errors, but it is not working as it it should. Could you help me and advise me where I am going wrong?

IF{ProductGroups.Name}="RCP" then
Sum ({ProductsSoldPd.Quantity},{Users.LoginName} )else 0

My aim is find out how many itmes in a specific product group a user sells.

Many Thanks
dannyb

 

[MCuthill]

dannyb,

For a conditional sum, it is best to work at the details level, instead of the group (though the group level can work). If I understand your intent, the following should work; then sum on your group level to see the summary.

{@YourNewFormula}

[blue]IF[/blue] {ProductGroups.Name}="RCP" [blue]THEN [/blue]{ProductsSoldPd.Quantity} [blue]ELSE[/blue] 0

*This formula will populate the quantity in instances where the Product Group Name of the record is "RCP".

Cheers! Hope this helps!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[dannyb29]

Thank you.
I guess I was over complicating it!