M
Max
Hi,
Is it possible to have different Select Expert formula for
different column or Fields at once? I can't figure out
how to calculate totals for different fields such as count
and total of sales for different years WHILE excluding
details (rows) having values of 0 for sales.
For example if I want to count and sum each record for
each year while EXCLUDING records having Sales of $0:
Year1 Year2 Year3
Count 5 7 8
Total 100 500 800
This would require a different Select Expert formula for
each year and not one for all the years!
How can I get counts and sums different for each years?
Help would be appreciated.
Regards,
Max.
Is it possible to have different Select Expert formula for
different column or Fields at once? I can't figure out
how to calculate totals for different fields such as count
and total of sales for different years WHILE excluding
details (rows) having values of 0 for sales.
For example if I want to count and sum each record for
each year while EXCLUDING records having Sales of $0:
Year1 Year2 Year3
Count 5 7 8
Total 100 500 800
This would require a different Select Expert formula for
each year and not one for all the years!
How can I get counts and sums different for each years?
Help would be appreciated.
Regards,
Max.