Active form and format based on value

[EP_explorer]

I'm newbie in the Active forms and I tried to create format based on the cube value
but it seems I did something wrong.

So in attached picture Active form based on Sdata sample.

10.JPG (63.01 KiB) Viewed 6118 times

The idea is simple - if the value in Jan>0 i'm using format 1 else I'm using format N

So you see that I write formula in column A for first row =IF(C17>0;1;"N") and you can see that for Canada in column A puts N
but anyway it shows in yellow if it has format 1

What do you think it is necessary to do?

[tomok]

What is the range definition for TM1RPTDATARNG1, TM1RPTFMTIDCOL, and TM1RPTFMTRNG?

[Andy Key]

You need to consider the order in which Excel and TM1 are populating the cells that you are referring to during the rebuild of the active form. When the part of the processing that applies the appropriate formatting is executed, C17 is probably still waiting to be calculated.

Change your formula in A17 and replace the reference to C17 with the same formula that is in C17, but change the DBRW to DBR. i.e. =IF( DBR(<parameters>) > 0; 1; "N")

Alternatively, if all you are trying to do is base the row formatting on the values of the data within the report, then why not just use simple conditional formatting rather than going to the extra processing expense of all those DBRs? You just need to remember to apply the conditional formatting to the rows in the format area.

[EP_explorer]

What is the range definition for TM1RPTDATARNG1, TM1RPTFMTIDCOL, and TM1RPTFMTRNG?

I did the simple thing - create an Active form and connect to one view of one Cube on Sdata server.
It put s the expression
=IF(TM1RPTELISCONSOLIDATED($B$17;$B17);IF(TM1RPTELLEV($B$17;$B17)<=3;TM1RPTELLEV($B$17;$B17);"D");"N")
in Column A - it works norvally

After it I changed this expression in A column to my one.

So you can see all formulas in the next picture.

01.JPG (136.38 KiB) Viewed 6052 times

And I don't know where I can see TM1RPTDATARNG1, TM1RPTFMTIDCOL, and TM1RPTFMTRNG

[EP_explorer]

You need to consider the order in which Excel and TM1 are populating the cells that you are referring to during the rebuild of the active form. When the part of the processing that applies the appropriate formatting is executed, C17 is probably still waiting to be calculated.

Change your formula in A17 and replace the reference to C17 with the same formula that is in C17, but change the DBRW to DBR. i.e. =IF( DBR(<parameters>) > 0; 1; "N")

Yes. I tried it - it didn't help

[EP_explorer]

Alternatively, if all you are trying to do is base the row formatting on the values of the data within the report, then why not just use simple conditional formatting rather than going to the extra processing expense of all those DBRs? You just need to remember to apply the conditional formatting to the rows in the format area.

Yes, it is good idea. But I also want to learm something about Active Forms. May be it is useful thing

[EP_explorer]

What is the range definition for TM1RPTDATARNG1, TM1RPTFMTIDCOL, and TM1RPTFMTRNG?

Found this parameters ))

02.JPG (83.47 KiB) Viewed 6043 times

[EP_explorer]

You need to consider the order in which Excel and TM1 are populating the cells that you are referring to during the rebuild of the active form. When the part of the processing that applies the appropriate formatting is executed, C17 is probably still waiting to be calculated.

Change your formula in A17 and replace the reference to C17 with the same formula that is in C17, but change the DBRW to DBR. i.e. =IF( DBR(<parameters>) > 0; 1; "N")

Yes. I tried it - it didn't help

You know - you were right. DBR helps (I tried DBRW).