Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
My Objective is to make my Flag table more dynamic by using SET.
My flag table 1 :-
Expression :-
money(
Sum (if($(ColumnDim3), sales)/1000/$(Columndim89))
, $(vMoneyFormatK))
Dimension :-
=if(
aggr(
(Sum (if($(ColumnDim3), sales)) - Sum (if($(ColumnDim4), sales))) / Sum (if($(ColumnDim4), sales))
, $(ColumnDim101)) <= $(iDiffValues) / 100
, $(ColumnDim101))
I try convert to SET table 2 :-
Expression :-
Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/$(Columndim89)/1000)
I don't know how to convert dimension to SET ( Table 2) , when i turn on current mth and yr , table not working .
Hope some one can advise me.
Paul
When I click the step 2 button, both the tables don't show anything. Both the tables don't work? What is the expected output?
Hi sunny
I will prepare another new table which is more easy for you to help me.
Pls wait .
Paul
Sent from my iPhone
Hi Sunny
My QV Table.