How to write different formulae for each cell?

[Shubham_Deshmukh]

	LY	LY LM	YTD	YTD LM
A	*
B
C

* = Formulae

I have such situation, in which neither first row nor first column is dimension.

We have to manually write formula for 1 row 1 column , 2 row 1 column , ......... matrix like this.

Please help.

[shraddha_g · Accepted solution]

I could only do this:

put your expressions into this again with proper backets..

If(Wildmatch(Valuelist('PRO','HFRP','WEB'),'PRO') ,

if(Wildmatch(Valuelist('Gross','Net','L2S','CPS'),'Gross'),

Expression1,

If( Wildmatch(Valuelist('Gross','Net','L2S','CPS'),'Net'),

Expression2,

If(Wildmatch(Valuelist('Gross','Net','L2S','CPS'),'L2S'),

Expression3,

If(Wildmatch(Valuelist('Gross','Net','L2S','CPS'),'CPS'),

'-'

)))),

If(Wildmatch(Valuelist('PRO','HFRP','WEB'),'HFRP') ,

if(Wildmatch(Valuelist('Gross','Net','L2S','CPS'),'Gross'),

Expression1,

If(Wildmatch(Valuelist('Gross','Net','L2S','CPS'),'Net'),

Expression2,

If(Wildmatch(Valuelist('Gross','Net','L2S','CPS'),'L2S'),

Expression3,

If(Wildmatch(Valuelist('Gross','Net','L2S','CPS'),'CPS'),

'-'

))))

,

If(Wildmatch(Valuelist('PRO','HFRP','WEB'),'WEB') ,

If(  Wildmatch(Valuelist('Gross','Net','L2S','CPS'),'Gross'),

Expression1,

If(Wildmatch(Valuelist('Gross','Net','L2S','CPS'),'Net'),

Expression2,

If( Wildmatch(Valuelist('Gross','Net','L2S','CPS'),'L2S'),

Expression3,

If(Wildmatch(Valuelist('Gross','Net','L2S','CPS'),'CPS'),

'-'

))))

)))

[Shubham_Deshmukh]

Same thing  I hv done.

No problem Thanks alot for the help.

I am on client side & U helped me alot.

Thankssss 🙂

[Shubham_Deshmukh]

Hey Shraddha, It's working Yipiiiiiiiiiiiiiii..

Thank u sososos much

[shraddha_g]

Cheers!

[Shubham_Deshmukh]

That solution is working fine Shraddha.But, if there are some derived expressions then it is taking too much time.

eg.

e= c + d

So, what I m doing , Exp(c)+Exp(d)

And if my expressions of C and D are too large.Working Fine but taking too much time.

So Is there any other way??

[shraddha_g]

ideally it should not take time..

Try to create variable for those 2 expressions and then use those variables in expressions

[Shubham_Deshmukh]

Hey shraddha,where r u  now ?

Means in which company u r working?