Skip to Content
0

Cross Tab not showing Formula in Available Field

Sep 26, 2017 at 06:09 AM

20

avatar image

Hello,

I want to know the reason why my cross tab not showing formula in available fields to summarize it. I want to summarize FacShare formula highlighting in red in my cross tab.

This is my report:

This my Cross Tab :

My formula FacShare is :

(({@Mang_Fee_Amount}*{@Fee})/100 )

Any Help would be highly appreciated. TIA.

e0fml.jpeg (212.7 kB)
awn4r.png (695.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Sep 26, 2017 at 09:35 AM
0

You also need to show contents of @Mang_Fee_Amount and @Fee

If they contain summaries or Whileprinting formula then they will not be available to be summarised in Cross Tab

Ian

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hey Ian,

@Mang_Fee_Amount =

if {ds_MngFeeComm.MANGE_FEE} > 0
then
(({@PROFIT}*{ds_MngFeeComm.MANGE_FEE})/100 )/365
else 0

and @Fee =

whileprintingrecords;
global numbervar GTfees;
if isnull({@Fee%}) or {@Fee%} = '' or {@PROFIT} <= 0.00 or {@PROFIT} <= 0.01
then GTfees := 0.00
else
GTfees := tonumber(Replace(Replace(Replace(Replace(Replace({@Fee%},' ',''),CHR(13),''),':',''),'-',''),'|',''));

0

whileprintingrecords;

using that in Fee will prevent the formula being available in Cross tab

Ian

0