Filtering a portal and report field

[Enigma20xx]

I am working with INT and MOD functions to generate receipts.

 

For example an amount splitted into 5 receipts.

The first 4 have the highest integer and the 5th has the remainder.

 

What I would like to accomplish is to show through a portal a calculation field with the result.

 

I have made a sample file to explain my idea.

 

As always, thank you very much for your help.

NumberOfReceipts.zip

[eos]

The following calculation assumes that you always generate the receipts via script in the given order and there are no more than two distinct values; it also takes into account the scenario where all receipts are for the exact same amount, or when there is only receipt. (IMO, all this is easier to take care of in a recursive CF …) 

 

In Customers, create a calculation field as

Let ( [
cnt = Count ( Child::Amount ) ;
theFirst = Child::Amount ;
theLast = Last ( Child::Amount ) ;
isSame = theFirst = theLast ;
cntOne = Case ( isSame ; cnt ; cnt - 1 )
] ;
List (
cntOne & Case ( cntOne > 1 ; " receipts " ; " receipt " ) & "à $" & theFirst ;
Case ( not isSame ; "1 receipt à $" & theLast )
)
)

[Enigma20xx]

Sorry for the "gap", I've been a bit busy.

 

Wow, the Let function is still a bit complicated for me, I'm trying to work on it.

 

I have made some changes in the sample file because it was ill-designed (I tried to make it simple and I did it wrong).

 

 

Working with your advice I'm still not able to make work two things, to filter the portal by customer ID, and to make your let function work individually by customer ID, now it works but it returns the first amount and the last one, but of all receipts of that record.

 

As always thank you for your great help.

NumberOfReceiptsV2.zip

[eos]

Sorry for the "gap", I've been a bit busy.

 

Aren't we all …? 

 

Your file lacked a Receipts TO that was uniquely bound to a ClientParent combination. It should now work as expected.

 

I've added a script/button that lets you select one or more customers to filter the portal and gives some visual feedback. Hope this gets you going for further endeavors …

NumberOfReceiptsV2_eosMOD.fmp12.zip

[Enigma20xx]

Thank you very much Eos, your idea goes even beyond mine.

You saw further problems I didn't spect.

As always incredible help from you.