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
Go to Solution.
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
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 lot