Jump to content
Salesforce and other SMB Solutions are coming soon. ×
  • 0

Count Subsummary


paulo.casa
 Share

Question

Hi

If I have a subsummary (A) and this subsummary have another level of  subsummary (B), how can I count on subsummary A the number of occurences of the subsummary B? 

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0
On 8/18/2020 at 6:33 PM, Steve Martino said:

How about you show us some screenshots and a better description about what 'A' & 'B' are suppose to represent?

 

Hi

The goal is to count, on the green subsummary, the number of yellow occurences , no mather what is inside the yellow.

Thanks for the support.

Paulo

Screen_01.JPG

Link to comment
Share on other sites

  • 0

The distinction between one yellow bar and the next appears to be the date, yes?  So for any green bar (Year, I assume) if you have a head-count of all the dates for which actual records (white bars) exist, that's your number.

One approach is to make a calcfield abstracting out the year (hence it returns "2020" for any date in the year 2020), selfjoin it across your table to make a 2nd table occurrence, call it ByYear or some such thing; then you can define a value list of related values of ByYear::Date, which gives you non-repeating list; then you can use   ValueCount (ValueListItems (Get(FileName); "YourValueList")) and that's the number for your green bar.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use