topic Re: how to bypass the field with the before function in App Development

how to bypass the field with the before function

kavita25 — Mon, 20 Dec 2021 21:08:46 GMT

Hello Everyone,

I want to bypass or restrict the field from the before function. Following is the logic I am using:

(Before (total
(RangeSum(Before(count (distinct {<month-={'Q1','Q2','Q3','Q4','YTD','FY'}>}complaintid),0,ColumnNo()))),18))

Or let me know how can I achieve the previous year data with the logic:

count (distinct {<month-={'Q1','Q2','Q3','Q4','YTD','FY'}>}complaintid)

Thanks & Regards,

Kavita

@tresB @sunny_talwar

Re: how to bypass the field with the before function

kavita25 — Wed, 26 Aug 2020 15:40:30 GMT

Hello Everyone,

@sunny_talwar

I am still struggling with the below logic.

Is there any way to bypass the filter inside the before total using the below logic:

(Before (total
(RangeSum(Before(count (distinct {<month-={'Q1','Q2','Q3','Q4','YTD','FY'}>}complaintid),0,ColumnNo())))

As i want to use two before to get the previous month using Rangesum and for accumulation for the previous value.. I am using Before and Rangesum in the pivot table.

Regards,

Kavita

Re: how to bypass the field with the before function

sunny_talwar — Wed, 26 Aug 2020 17:52:59 GMT

Can you share a sample where we can see the issue?

Re: how to bypass the field with the before function

kavita25 — Tue, 08 Sep 2020 14:50:05 GMT

Hello @sunny_talwar

I have attached the sample file. My requirement is to show the previous year rangesum values in the current year in pivot table.

I have tried the below logic:

(Before (total
(RangeSum(Before(count (distinct {<Year=, Month-={'Q1','Q2','Q3','Q4','YTD','FY'}>}complaintid),0,ColumnNo()))),18))

It works.. but on year selection it shows blank values.

Thanks..

Regards,

Kavita

Re: how to bypass the field with the before function

kavita25 — Wed, 09 Sep 2020 16:48:54 GMT

@sunny_talwar : Is there any other way to resolve the issue or what I am doing is not correct??

Please guide me on this.

Regards,

Kavita

Re: how to bypass the field with the before function

sunny_talwar — Wed, 09 Sep 2020 17:10:05 GMT

@kavita25 What is the expected output? Would you be able to share the output you expect to see in an Excel file?

Re: how to bypass the field with the before function

kavita25 — Mon, 14 Sep 2020 11:56:29 GMT

@sunny_talwar : I have attached the output.

Basically I want to show the data of Previous year in Current year with the rangesum logic.

Thank You.

Regards,

Kavita

Re: how to bypass the field with the before function

kavita25 — Tue, 15 Sep 2020 08:18:36 GMT

Hello Everyone,

Kindly help me to resolve the issue, I have tried the same multiple times.

@sunny_talwar @Taoufiq_Zarra .

Regards,

Kavita

Re: how to bypass the field with the before function

kavita25 — Mon, 21 Sep 2020 06:44:14 GMT

@sunny_talwar @Taoufiq_Zarra Is there anyway to show the previous year in current year with the rangesum function?

Please let me know, facing the same issue, need your help.

Regards,

Kavita