5 Replies Latest reply: Mar 21, 2018 1:13 PM by Sunny Talwar RSS

    SetAttribute and sub-SetAttribute(Sum({<...>})=0)

    Manu Fernandes

      hello,

       

      I need some help to build a setattribute with sub-setattribute.

      My model is simple.

      doc:

      Customer,

      Year,

      YearAgo ( load from year(Today() - Year)

      Sales;

       

      I'll found my 're-born' Customer; the one who have Sales on YearAgo=0 and without Sales on Yeargo=1

       

      Here is my formula

      Sum({$<YearsAgo={0},   Customer={" =Sum({$<YearsAgo={1}>} Sales)={0}" } > } Sales)

       

      but I get 0.00 ... sure there is some.

      What's wrong on the syntax?

       

      Thanks for any help.

      Manu