FORMULA RELATED ISSUE
i have a lineitem Has Data? which is a boolean format and in the same module i have product and store dimensions
i want to write a formula in such a way that if a store has a particular product then the corresponding boolean box has to be checked
please help me with a resolution
What is the line item that determines the store has the product or not. Do you have historical sales?
Assuming, you have historical sales number in this module, it will be like
Historical sales > 0
thnks for responding arun
but here i have historic volumes and jus tried as per ur advice but it is checking all the boxes
and the hint given is to use time sum and if condition
TIMESUM(<<Historical volumes>>) > 0
Replace Historical volumes with a line item that you have in your module which has the historical volume data.
Thank you so much Arun
it worked good
Thanks a lot0