freeze some fields not All !!!

[patrou38]

Hello, in the example attached, as you will see in my expression  I put a '1' (=Sum({1} Amount)) to ignore all selections but how can do in my example to ignore all action in the 'Week' field but take into account actions in the 'Site' or 'People' field. 

thank you for help and support.

Best regrds,

Patrick

[sunny_talwar]

You should be able to do this to ignore selection in Week field....

Sum({<Week>} Amount)

[patrou38]

thank you for your answer Sunny,

But if I write something like = count({<Week>}Lot), all actions in all fields are impacted my result 😞

[sunny_talwar]

All fields? Yes, Count({<Week>} Lot) is only ignoring selection in Week field... what other field is impacting selection which you don't want to impact selection?

[sunny_talwar · Accepted solution]

Alternatively, if you only want to allow selection in Site and People, you can try one of these

Sum({1<Site = $::Site, People $::People>} Amount)

Sum({1<Site = p(Site), People p(People)>} Amount)

[gys1992infosys]

Hi Patrick,

For example: sum({<Field Name={''}>}Amount), it will be ignore the field name selection that the condition with underline.

Thanks,

Gary

[patrou38]

Great, it's work.

thank you to all !!!

Patrick

[gys1992infosys]

Sorry, a mistake,correct is : sum({<Field Name=  >}Amount), make the condition blank.