Front End Logic Calculation

[Anonymous]

Dear All,

Need a small help to build a logic at front end.

I have attached a simple test file(attached) which is I am getting in my report but I have to achieve the result of target excel(attached).

Flow:

I am getting a dynamic value through a variable say VDyanmicvariable=50 which is Initial OutStanding, now I have required fields to calculate Closing OutStanding.

and for next month, my initial outstanding will be closing outstanding of previous month.

Please suggest, how I can calculate at front end???

Regards,

Balraj

[MarcoWedel]

Hi,

maybe

var1=min(total Date)

and

if(Date=$(var1) ...

could work.

min(Date) in an expression when using Date as dimension should deliver just the same Date value per Date/Dimension value.

hope this helps

regards

Marco

[Anonymous]

Say,

If user select a Calender 2014, Apr the my makedate() function will make it 1st April 2014 and in variable value will be 50 as per last thread.

How min(Date) which will return 1st April 2014 only would work similar to previous to previous functionalities??

[Anonymous]

Here each time I need current and previous values of sales till my Closing Outstanding becomes<0.

I have done this at back end but now things are dynamic, I have to calculate them at front end only

I need a function which would work similar to previous() at front end.

Pls Suggest.

[jyothish8807]

Tried this also,but didnt work

Regards

KC

[MarcoWedel]

Hi,

I'm not quite sure about what you like to achieve with this expression, but tried for a solution.

Is this what you are looking for:

regards

Marco

[Anonymous]

It is required for Daily Sales Outstanding.

and it should be like this:

Date	Initial O/S	Sales	Collection	Claims	Closing O/S	Days
Apr-14	50	20	10	5	55	<120
May-14	55	15	5	10	55	<120
Jun-14	55	10	10	5	50	<120
Jul-14	50	15	10	5	50	105
Aug-14	50	10	8	10	42	104
Sep-14	42	10	10	10	32	84

Closing Outstanding would be compared with current sales and previous sales.

We can write one more if statement to make it <120 days.

[Anonymous]

Hello Marco,

It is required for Daily Sales Outstanding.

and it should be like this:

Date	Initial O/S	Sales	Collection	Claims	Closing O/S	Days
Apr-14	50	20	10	5	55	<120
May-14	55	15	5	10	55	<120
Jun-14	55	10	10	5	50	<120
Jul-14	50	15	10	5	50	105
Aug-14	50	10	8	10	42	104
Sep-14	42	10	10	10	32	84

Closing Outstanding would be compared with current sales and previous sales.

We can write one more if statement to make it <120 days.

Any update on this???

[Anonymous]

Marco,

Yes, I am looking for similar kind of column to add...

Could you help me to get this expression?

Regards,

Balraj

[Anonymous]

KC,

Have you got any success to get this field NewColumn say Days?

Marco had done this but not getting any response from him..

Regards,

Balraj