I am new to Jet Reports and have found ways to accomplish almost everything we need in reporting with one exception. I created a Join to combine entities in a combined report. It works fine if all entities are 100% but I have not found an easy way to include say 20% of the last entity rather than 100%.
On my options page I use a join formula for included entities:
=NP("Join", C6:C13,"|")
It returns my entity list from cells C6 to C13 as 330|325|341|365|370|0|129|272 which I then refer to in my report page GL formulas as the entity segment.
My problem is I only want our ownership percentage of income and expenses which is 20% for entity 129 and .03% for entity 272.
I did get the correct result in the reports by using nested "Ifs" but that solution is creating other problems and returning #value errors even though I'm using "@@" on blank accounts. I could continue down this route and try to add "Iferror" functions but was hoping to find a more efficient method in the initial Join function defining the entities of the combined report.
If you have had any success doing this on the Join, please let me know how this might be accomplished.
Thank you!
