Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
i have a button that i want that a click will make a selection in project field-
so i add action
select in field
the field name -"Project"
in the search string-
='('&concat(if(Aggr((Sum({<[BUDGET VERSION]={1)}>}ActualCurrentBook_$(vFinanceFormula)))/
(Sum({<[BUDGET VERSION]={1}>}BudgetCurrentBook_$(vFinanceFormula))),Project)>=1,Project),'|')&')'
and when im clicking its diong nothing!
i put the expression in a textbox-
='('&concat(if(Aggr((Sum({<[BUDGET VERSION]={1)}>}ActualCurrentBook_$(vFinanceFormula)))/
(Sum({<[BUDGET VERSION]={1}>}BudgetCurrentBook_$(vFinanceFormula))),Project)>=1,Project),'|')&')'
its gives me- (111|232|111)
what am i doing wrong?
adi
tnx good to know...
but this is not my problem...
im tring to make a selection in a field with an action.
i cant find the expression that i shoud insert
because my expression is not working and i dont know why-
='('&concat(if(Aggr((Sum({<[BUDGET VERSION]={1)}>}ActualCurrentBook_$(vFinanceFormula)))/
(Sum({<[BUDGET VERSION]={1}>}BudgetCurrentBook_$(vFinanceFormula))),Project)>=1,Project),'|')&')'
someone?
?
Looks right... Try to hardcode (111|232|111), and try to use ToggleSelect, although Select must work too.
Besides, use distinct concat avoid 111 twice
hi,
tnx
i think i know what the problem bul i dont know what to do.
i will explain-
when im using the function -
GetFieldSelections(Project)
i get - 111, 222, 333 and not- (111|222|333)
i one of my other models i did get (111|222|333) and the selection worked in that model.
but i dont know why its not the same and where can i control it...
someone can help?
You can define the delimitter as an argument for 'getfieldslections' and then add the '(' and ')'.
='(' &GetFieldSelections(Project , '|') & ')'
tnx good to know...
but this is not my problem...
im tring to make a selection in a field with an action.
i cant find the expression that i shoud insert
because my expression is not working and i dont know why-
='('&concat(if(Aggr((Sum({<[BUDGET VERSION]={1)}>}ActualCurrentBook_$(vFinanceFormula)))/
(Sum({<[BUDGET VERSION]={1}>}BudgetCurrentBook_$(vFinanceFormula))),Project)>=1,Project),'|')&')'
someone?
Hi Adi,
Try this expression
='('&concat(Aggr(if((Sum({<[BUDGET VERSION]={1}>}ActualCurrentBook_$(vFinanceFormula))/
Sum({<[BUDGET VERSION]={1}>}BudgetCurrentBook_$(vFinanceFormula)))>=1,Project), Project),'|')&')'
What is there in vFinanceFormula? Can you elaborate what you are try to do with a sample file?
Regards,
Jagan.
tnx evryone!
it was a syntax mistake
Hi Adi,
Close this thread.
Regards,
Jagan.