Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
How to make modifiers of set expression dynamic ?
I have two fields called Entityand SubArea .
My expression should be something like ;
sum({1<Field_of_My_choice={'A'}>}sales) .
Script
LOAD Area,
Entity,
Sales,
SubArea
FROM
[Dynamic Modifier.xlsx]
(ooxml, embedded labels, table is eNTITY);
Fields:
LOAD * INLINE [
Field
Entity
SubArea
];
I have solved this using pick match , though . But wanted to know if there is other way !!!
Field of my choice means user has ability to select modifiers
Please try with
sum({<$(=Only(Field))={'A'}>}Sales)
Though sum({<$(=Only(Field))={'A'}>}Sales) worked but curly bracket before 'A' is having some red highlighted
it´s not a problem.
The parser editor isn´t understanding what we are trying to do.
Keep calm, it will work
Thank you Anjos