FORMULA RELATED ISSUE

[aditya]

hello community,

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

sai.

[ArunManickam]

Hello @aditya 

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

Thanks

Arun

[aditya]

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
Thanks

[ArunManickam · Accepted solution]

Hello Aditya,

TIMESUM(<<Historical volumes>>) > 0

Replace Historical volumes with a line item that you have in your module which has the historical volume data.

Thanks

Arun

[aditya]

Thank you so much Arun 

it worked good 

Thanks a lot