FORMULA RELATED ISSUE

Options
aditya
aditya Member, ALL USERS, GroupMember, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

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.formula related issue.PNG

Comments

  • aditya
    aditya Member, ALL USERS, GroupMember, Community Member, Certified Model Builder Posts: 5 Occasional Contributor
    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
  • aditya
    aditya Member, ALL USERS, GroupMember, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

    Thank you so much Arun 

    it worked good 

    Thanks a lot